unchangable fields

[Jean-Paul De Winter]

Hi,
Is there a way to prevent a user from going to an entryfield?... moving the
cursor and clicking may not do anything...
Thanks

 

[Tony C]

You cannot prevent a user from selecting a field on a form
per se, however there are two alternative methods you
could try: -

1. Disable the Entry Field, this will "grey out" the
field.
2. If you have other actions that are dependent on the
Entry Field, then add this code to the Entry Field's "On
Got Focus" Procedure: -

Me.Record.SetFocus

Note, change the word "Record" to a valid object name on
the Form.

HTH


Tony C

 

[Rick Brandt]

Hi,
Is there a way to prevent a user from going to an entryfield?... moving the
cursor and clicking may not do anything...
Thanks

Look at the properties Enabled and Locked.

NORMAL:
Locked = False
Enabled = True

Locked = True
Enabled = True
(User can put cursor in field, but not change it)

Locked = False
Enabled = False
(User cannot put cursor in field. Field appears grayed out)

Locked = True
Enabled = False
(User cannot put cursor in field. Field has normal appearance)