Using the Width variable

[kamathmanoj]

Hi Everyone,



i have a backend Access database which has the field named WIDTH. I created a form that has the control set to this field.
My issue is that when I try to use Me.Width (caps or otherwise), its returning the width of the form instead of the number entered in that field.

How do i get around this?

Regards,
manoj

[June7]

Width is a reserved word (it is a property). Best to rename the field.

However, try enclosing in [ ] - Me.[Width]

Or name control different from field, such as tbxWidth and refer to control bound to field.

Or try Me!Width. The bang (!) will see field, not property.

Access is not case sensitive by default.

[Micron]

I created a form that has the control set to this field

Then regarless of spelling or anything else, Me represents the form. You can't use ME to refer to a control on your form.
Me.ControlNameHere.Width = [Width]

suggest you avoid using reserved words

[June7]

@Micron, I expect OP was trying an expression like your example so Me.[Width] is certainly acceptable if Width was name assigned to control.

[kamathmanoj]

Thank You. I referred to the name assigned to the control. I was trying to do two things:
1. Color the control red/green based on the value in the control
2. Pass the value in the text box to a global variable for use elsewhere.

Both things worked! This forum is the best! Thanks for sharing the workaround June7 & Micron.

Micron - I couldn't actually change anything in the table or the remaining database as it is complex and has many forms, queries and reports running that reference that one variable and half of them I could not even find if I tried hard enough.
I am not exaggerating - there are over 1000 tables, 100+ reports, countless queries and about 800 forms. Its is a fully functional ERP system loaded onto Access.

Regards,
Manny

[June7]

You are using VBA to color control? Why not Conditional Formatting?