auto set background color for textbox

D

dmshade3

Joined
Oct 20, 2005
Messages
1
Reaction score
0
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I change background color of Text Box based on condition? 1
Change text box background color depending on value in Label Reports 1
Textboxes show colored backgrounds 3
formatting comment's background color 1
Textbox Background Color 5
How can I set a subreport background to transparent? 3
Conditional Color of Report Object 4
set background color to transparent 3

Back
Top