PDA

View Full Version : Make a textbox read only?



Blasphemer
11-28-2008, 04:51 AM
Hi,

Is it possible to make a text box in access form read only? If so can someone tell me how?

Regards,

OBP
11-28-2008, 05:21 AM
With the Form in Design Mode and it's Properties showing, look for the "Enabled" Property, set it to "No" instead of yes and it will be "greyed out" so that it can still be read but not added to or edited.

Blasphemer
11-28-2008, 05:39 AM
Thanks !

CreganTur
11-28-2008, 07:55 PM
Another piece of information: If you set your textbox's Enabled property to 'No' and the Locked property to 'Yes' it will make it so the textbox is read only, but it looks normal- it won't be greyed out. It's a personal choice issue.

faisal3096
07-09-2014, 08:33 AM
Owesome... it took me hours to find out this.... :)

Movian
07-09-2014, 10:08 AM
Don't forget to mark your thread complete ;)

Bhatti1981
02-20-2021, 04:45 AM
Its an old thread but CreganTur (http://www.vbaexpress.com/forum/member.php?14154-CreganTur)'s solution is not working in 2016 Excel, ActiveX TextBox. I am setting the Enabled property to False and Locked to True but text box text is still greyed out. Any suggestion?

SamT
02-20-2021, 09:11 AM
Use a Label formatted to look like a TextBox.