Formatting of fields

[nike2000]

Does Access 97 allow for a field to be formatted in Bold or different colour Font, dependant on the result of an Iif statement?
Any help would be appreciated.Thanks,
Nike

 

[SgtJarrow]

Not the field itself.....but if you are using code to fill the field, or even use some code to evaluate the field, you can set the font stype property as necessary...

****************************
Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III
MCSA, CNA, MCP, Network+, A+
w: robert.l.johnson.iii@citigroup.com
h: wildmage@tampabay.rr.com

 

[nike2000]

hi mstrmage1768,
how would i set code to evaluate the field? (do you mean an iif statement?) if so, how would i go about setting the font type property.
thanks for your reply.
Nike

 

[SgtJarrow]

No problem....can you give a bit more details about your setup??? First and foremost, is the form continuous or singee record at a time. ? Second, is the data in the field text or numeric? Finally, what are some of the options and what the equate to...i.e. 1, 4, and 5 = bold, 2,3 and 6 = italic, 7,8 and 9 = normal.

****************************
Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III
MCSA, CNA, MCP, Network+, A+
w: robert.l.johnson.iii@citigroup.com
h: wildmage@tampabay.rr.com

 

[nike2000]

I would like an iif statement that if the result is 'No' would be highlighted by red text for example.
All of these fields would be Yes/No fields.
Therefore 'No' what equal Bold Red Text. If it were 'Yes' the field would be blank.
The Form is continuous
Thanks again,
Nike

 

[nike2000]

I mean Red bold text.
Nike

 

[WildHare]

Check out conditional formatting for forms or reports. It might do what you want...

FORMAT/Conditional Formatting on the design view menu.

Works just like Excel. Access 2K and above.

Jim

Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm

 

[nike2000]

i'm using Access 97, does that allow conditional formatting??
Nike

 

[WildHare]

Uhh..no. Between the A97 and the Continous form, you're in for some trouble.

There have been some 'fixes' posted on various web sites that purport to handle your situation. I have not tried any of them. You might try

http://mvps.org

and check the Access section.

Sorry.

Jim

Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm