change background color on datasheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a datasheet where some of the fields are locked from the user so they
cannot change them. Is there a way to shade these fields to make is obvious
to the user that they do not need to click in them ?
Thanks
 
I have a datasheet where some of the fields are locked from the user so they
cannot change them. Is there a way to shade these fields to make is obvious
to the user that they do not need to click in them ?
Thanks
Click to expand...

If by Datasheet you mean the Table in Datasheet view, then your users
should not be seeing or using the table at all. Tables are for data
storage, not data entering or viewing.

However, if you mean Form Datasheet View, then all you need do is set
the control's Locked property to Yes (in Form Design View).
Change the backcolor of that control to what ever you wish.
That control will have it's own color, even in Form Datasheet view.
 
Back
Top