I am limited to ONLY native tools/controls (non-html etc.) within Access 97 for a project at my work, due to the constraints placed on the pc by those who support it.....
I need to be able to set the background of a textbox based on the contents ....
ie - if (textbox1="On"),background=yellow,[else]white ....
I know this will have to be a VBA Script or Module in Access 97.... and I know how to define or locate the "object names" to small extent.... but I am not able to figure out how to script the logic or find any exmaples of it in any of my sample databases......
Can anyone tell me how to do this?
Thanks....
Mark
I need to be able to set the background of a textbox based on the contents ....
ie - if (textbox1="On"),background=yellow,[else]white ....
I know this will have to be a VBA Script or Module in Access 97.... and I know how to define or locate the "object names" to small extent.... but I am not able to figure out how to script the logic or find any exmaples of it in any of my sample databases......
Can anyone tell me how to do this?
Thanks....
Mark