textbox

[igg via AccessMonster.com]

my msaccess2003 form has a subform. subform has a textbox. I like to set
textbox's foreground color always to red. How is this done?.

 

[PieterLinden via AccessMonster.com]

my msaccess2003 form has a subform. subform has a textbox. I like to set
textbox's foreground color always to red. How is this done?.

Open the subform in design view, change the fore[ground ]color property to
red... whatever the number is for it...

 

[igg via AccessMonster.com]

opened the subform in design view. selected the textbox. right clicked ->
property->Format. changed forecolor to 255 but no changes to the color of
text itself occurred.

my msaccess2003 form has a subform. subform has a textbox. I like to set
textbox's foreground color always to red. How is this done?.

Open the subform in design view, change the fore[ground ]color property to
red... whatever the number is for it...

 

[Linq Adams via AccessMonster.com]

If the subform is being displayed in Datasheet View, as they frequently are,
no formatting of this type is going to change how it's displayed. Formatting
for Datasheets is controlled thru Tools - Options, and apply to all textboxes
in on Datasheets in the database.

What you can do is use Conditional Formatting to trick Access.

In Design View, select the textbox, then goto

Format - Conditional Formatting

Select "Expression Is"

then, in the next box, enter

Not IsNull9[YourTextboxName])

Now select he forecolor you want.and check OK.

 

[Linq Adams via AccessMonster.com]

Sorry about the typo!

Not IsNull9[YourTextboxName])

should be

Not IsNull([YourTextboxName])