Change textbox color based on a condition

  • Thread starter Thread starter T. W.
  • Start date Start date
T

T. W.

Hello all,
How do I write an If statement in the FontColor property so that if a
field has a number in it, it turns say green (green being 32768)?

Thank you beforehand
 
Hello all,
How do I write an If statement in the FontColor property so that if a
field has a number in it, it turns say green (green being 32768)?

Thank you beforehand
Click to expand...

You don't... not there.

If you have A2000 or later, select the textbox in design view and
choose Format... Conditional Formatting from the menu.

Put the condition in the textbox, using the "expression" option; and
select the color using the menu.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
I meant to say thank you for this earlier.
My apologies, it worked out fine and I appreciated the help (of course, now
I'm like a kid that learned a new trick).
 
Back
Top