remove leading space in field in Access

  • Thread starter Thread starter khaymon
  • Start date Start date
K

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.
 
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
 
Back
Top