question

Elise-6836 avatar image
0 Votes"
Elise-6836 asked Elise-6836 action

remove front and back blank space in Names in Ms. Access Visual Basic

What is the code to remove the front and back blank space in Names in Ms. Access Visual Basic?
For example

 ABCD EFGH   

for the above example;
spacespacespacespaceABCD EFGHspacespacespace

Please help83542-eg.png


office-access-dev
eg.png (616 B)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

thedbguy avatar image
0 Votes"
thedbguy answered thedbguy commented

Hi. Take a look here...

ltrim-rtrim-and-trim-functions


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.