467,118 Members | 993 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,118 developers. It's quick & easy.

gray-out and lock one subform record among many in datasheet view... HOW?



Well, I have the lock part figured out.. but how do I gray-out or put
in some type of visual effect that indicated that the row in the
subform is locked?

Thanks.

Si

Nov 14 '05 #1
  • viewed: 2376
Share:
1 Reply
You can kinda fudge it with conditional formatting on each control, setting
its ForeColor or BackColor so it appears greyed out.

As simpler and more efficient visual indicator might be a text box that
shows a little lock symbol to the left of the locked items. For example, if
wanted to lock all records where the DateEntered field is more than 30 days
ago, you would give the text box these properties:
Control Source: =(DateEntered < Date() - 30)
Font Name: Webdings
Then put 3 characters into the Format property:
semicolon (;)
backslash (\)
hold down the Alt key, and type 0207 on numeric keypad.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<sa****@gmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

Well, I have the lock part figured out.. but how do I gray-out or put
in some type of visual effect that indicated that the row in the
subform is locked?

Nov 14 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Akbarr | last post: by
1 post views Thread by susie_richie_30@yahoo.com.au | last post: by
6 posts views Thread by Srinivas Rao \(Rbin/eds2\) | last post: by
2 posts views Thread by allanon76@gmail.com | last post: by
5 posts views Thread by MC | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.