remove leading space in field in Access

[khaymon]

I'm trying to remove a leading space in a text field using the update query
and LTrim. I'm getting an error "Undefined function 'LTrim' in expression".
Please advise. Thank you.

 

[Jeff Boyce]

If Access believes LTrim() is undefined, perhaps your database file is
missing a reference. Open a code module, click on references, see if any
are prefixed with MISSING.

If so, uncheck that one, remember it, save/close the window. Re-open the
window, re-select the one that was missing, save/close the window. Now
recompile.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Al Campagna]

khaymon,
Sounds like a missing Reference.
Check out Doug Steele's page on resolving missing references...
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."