Formatting datasheets

[KevinNewtoAccess]

I am working on a form which contains 2 datasheet subforms.
It would be very helpful to highlight particular fields on the datasheet subforms using combinations of text colours / bold / italic etc.

I can adjust the text colour & appearance settings in the property box of these datasheets, and the text takes on the appropriate characteristic when in design mode, but as soon as I open the form for use, the text colour & effects revert to standard.

What am I doing wrong?

Any help would be much appreciated!
Kevin

 

[mikelt]

Have you tried setting the properties of indvidual fields via the text boxes in a form design view?

 

[Rohdem]

Why not have the subforms display continuous forms, rather than a datasheet. Then you can control colors, fonts.....whatever you want.
Mike Rohde
rohdem@marshallengines.com

 

[jimmythegeek]

Mike is right. In fact that is really the only way to do it, as you cannot control the characteristics of individual fields, or records in datasheet view. You can make the changes in form design view, but they do NOT carry over into the datasheet view.

You can make a continuous form look almost like datasheet if you do it right, and then you can control it like Mike said. Jim Lunde
compugeeks@hotmail.com
Custom Application Development