Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Formatting datasheets

Formatting datasheets

Formatting datasheets

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!

RE: Formatting datasheets

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

RE: Formatting datasheets

Why not have the subforms display continuous forms, rather than a datasheet.  Then you can control colors, fonts.....whatever you want.

Mike Rohde

RE: Formatting datasheets

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
Custom Application Development

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close