Link to home
Start Free TrialLog in
Avatar of Bob Stamm
Bob StammFlag for United States of America

asked on

Lock textbox from data entry

I have a access form with a textbox placed on it for a date field.  On dbl click I have code that fills in this textbox with the proper date.  All is well!!  My problem is that some users attempt to keyin the information without dbl clicking the textbox.  How can I eliminate this from happening.  I must be overlooking something as I assume this should be easy.

Ideas?
Thanks,
Bob
Avatar of flavo
flavo
Flag of Australia image

Hi RobertStamm,
Me.myTextBox.Enabled = False
Dave :-)
Hang on.. This wont work.. On the double click event of the textbox you are firing this?
Dave
Avatar of Bob Stamm

ASKER

Yes.  If I enable = false, I cant double click.
ASKER CERTIFIED SOLUTION
Avatar of Leigh Purvis
Leigh Purvis
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
lol oh curse you all for typing while I was lol

Locking the textbox was the solution for me!  
Thanks for the help.
Bob