Formatting datasheets

KevinNewtoAccess · Dec 21, 2000

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 · Dec 21, 2000

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

Rohdem · Dec 21, 2000

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 · Dec 22, 2000

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Formatting datasheets

KevinNewtoAccess

Technical User

mikelt

Programmer

Rohdem

Programmer

jimmythegeek

Programmer

Similar threads

Part and Inventory Search

Sponsor