If the error states that the object named number_5 does not have this
method, chances are that it is not a text box.
Perhaps the field in the form's RecordSource is named number_5, but the text
box bound to this field is named something else, such as Text8.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
Enclose the name in square brackets.
For example,if the text box is named 5, use:
Me.[5].Locked = False
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
I'm trying to write some code that locks several controls on a
form...
Some of the names of the controls are numbers or have numbers in the
name.
I'm getting an error in VBA at run time, related to these numbers.
Do I have to change the names of the controls, or is there a work-
around?
thanks,
alex- Hide quoted text -
- Show quoted text -
Thanks Allen.
I also have a bound control named, e.g., Number_5.
Is there a special case for this? I tried putting the whole name and/
or the number in brackets...to no avail
alex
Rather than describing what you have done, it would be best to post the
actual code, including the event in which it occurs. Also, describe the
expected result, and what happens instead.- Hide quoted text -
- Show quoted text -
Here's the code: 'Me!NUMBER_5.Locked = False
I expect it to unlock the control named number_5
Instead I get a run time error: Object doesn't support this method or
property
I have other controls that are named with just numbers and Allen's
advise works fine.
I'm having problems however with alpha/numeric controls like
'Number_5'; the brackets don't work.
- Show quoted text -
