Share via

Space function in Access 2010 not being recognized

Anonymous
2012-07-18T03:07:53+00:00

I have an Access 2003 DB that has a MakeTable query. One of the fields is defined as ITEMKEY: [BOS_RAWDATA]![Part] & Space(17-Len([BOS_RAWDATA]![Part])) & "B" The purpose is to insert a "B" in the 18th position of the field, regardless of how long the [Part] field is ( it will never be longer than 15 characters). It worked fine in Access 2003, but when I run the query in Access 2010, I get the message "Undefined function Space in expression" When I go to the builder, Space is identified as a valid function. Any ideas?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
2012-07-18T03:43:14+00:00

My guess is you are missing a reference. Go to a code window > Tools > References and check for any missing ones.

The Space function certainly is still supported in A2010.

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-07-19T01:57:52+00:00

    That was it!!  missing reference to utility.mda.  I have several other databases that I will have to check out for this issue.  Thanks.

    Was this answer helpful?

    0 comments