Calculated unbound control in form returning wrong value (really wrong)

[samsquared]

I have a simple form that has room dimensions (from the Room_Dimensions table) for rental houses with these items:

• Property_ID
• Room_Type_ID
• Length
• Width
• Height

Length, Width, and Height are all numeric, precision 6, and 2 decimal places. I added a calculated field for the floor area as follows:


=[Width]*[Length]


Sample values I put in were Width = 10, Length = 15, and Height = 9. The resulting calculated area was 177645!! I then modified that control to "=[Length]*1" and added a second calculated control to be "=[Width]*1" to try to see what was going on (see attached photos).


Calculations using Height and Length are fine but not Width. I'm sure it's something simple but I really have no idea what is going on.

[moke123]

Width and height are reserved words and should not be used as field or object names.

[samsquared]

That was it - thanks for the quick reply! I don't use Access all the time so it didn't occur to me that they could be reserved words.

[moke123]

You're welcome.

here's one list http://allenbrowne.com/AppIssueBadWord.html