Change textbox color based on a condition

[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

 

[John Vinson]

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

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

 

[T. W.]

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).