Results 1 to 3 of 3

Thread: Length & Width

  1. #1
    Join Date
    Jan 2004
    Posts
    77

    Unanswered: Length & Width

    I've notice a situation in a few databases. One is where we track sidewalk construction. There are two called fields LENGTH and WIDTH. In my report I have text box with the control source =[Length]*[Width]. However it returns some bogus number. If I change the field names to something else like Width1, it works fine.

    Any ideas?
    Thanks,
    SKK

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    esskaykay,

    You've commited a cardinal sin in Access as well as most other languages!

    Width is a Reserved Word in Access. Naming a user defined variable with the name of a Reserved Word makes Access do all kinds of strange things. That's why Width1 works but Width doesn't!
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Jan 2004
    Posts
    77
    I will use Width1 in the future.

    Thanks,
    SKK

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •