remove leading space in field in Access



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


Jeff Boyce
Microsoft Office/Access MVP

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question