unchangable fields

  • Thread starter Thread starter Jean-Paul De Winter
  • Start date Start date
J

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
 
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
 
Jean-Paul De Winter said:
Hi,
Is there a way to prevent a user from going to an entryfield?... moving the
cursor and clicking may not do anything...
Thanks
Click to expand...

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)
 
Back
Top