View Full Version : changing a control property


bertiespiv
01-29-2009, 03:00 PM
I am trying to set the Enabled property to 'no' on a combo box from within a VBA module, to prevent the contents being changed.
I would have thought there would be a reference guide somewhere telling me what the property name is and the values it can take but I have searched for two hours now and cannot find anything. Am I missing something?
BS

pbaldy
01-29-2009, 03:04 PM
In my VBA help, it's under "Enabled, Locked Properties", found by searching for Enabled.

gemma-the-husky
01-29-2009, 03:46 PM
on the control, properties, its on the DATA tab - permitted values are yes/no (true/false)

bertiespiv
01-30-2009, 02:47 AM
Thanks for your responses. My question really was, is there a definitive list or quick reference anywhere that shows all the properties and their various values as this would be a useful thing to pin up on my wall rather than having to go into VBA/Access to determine.
I guess I will eventually remember them all but that could take some time!!

Thanks again