rtrim using the function a query

  • Thread starter Thread starter wgreen
  • Start date Start date
W

wgreen

I am trying to trim off the spaces in a text field. I started a make take
query and insert expr:Rtrim([item]) but when I run the query I gets errors.
"undefined function rtrim in expression". What I am doing wrong?
 
Sometimes Access can't recognize build in function because it's missing
reference.
To check that
Open the code, any where, or press Ctrl+g
in the menu bar select Tools > reference
check if the word missing apears next to any of the objects, if it does
ucheck that object if you have no use of it, or select a new location
 
I have checked and found only 1 reference that shows missing. How do you find
out if it is reference I need and how do you fix it.

Ofer said:
Sometimes Access can't recognize build in function because it's missing
reference.
To check that
Open the code, any where, or press Ctrl+g
in the menu bar select Tools > reference
check if the word missing apears next to any of the objects, if it does
ucheck that object if you have no use of it, or select a new location
I am trying to trim off the spaces in a text field. I started a make take
query and insert expr:Rtrim([item]) but when I run the query I gets errors.
"undefined function rtrim in expression". What I am doing wrong?
Click to expand...
Click to expand...
 
Does the reference look like something you need: Word , Outlook, XML ...

If you don't know, the best way is to uncheck it and then run compile on
your code, if you don't get any error message, there is a good chance you
don't need it.

--
Good Luck
BS"D


wgreen via AccessMonster.com said:
I have checked and found only 1 reference that shows missing. How do you find
out if it is reference I need and how do you fix it.

Ofer said:
Sometimes Access can't recognize build in function because it's missing
reference.
To check that
Open the code, any where, or press Ctrl+g
in the menu bar select Tools > reference
check if the word missing apears next to any of the objects, if it does
ucheck that object if you have no use of it, or select a new location
I am trying to trim off the spaces in a text field. I started a make take
query and insert expr:Rtrim([item]) but when I run the query I gets errors.
"undefined function rtrim in expression". What I am doing wrong?
Click to expand...
Click to expand...
Click to expand...
 
Thanks that fixed my problem.
Ofer said:
Does the reference look like something you need: Word , Outlook, XML ...

If you don't know, the best way is to uncheck it and then run compile on
your code, if you don't get any error message, there is a good chance you
don't need it.
I have checked and found only 1 reference that shows missing. How do you find
out if it is reference I need and how do you fix it.
Click to expand...
[quoted text clipped - 10 lines]
query and insert expr:Rtrim([item]) but when I run the query I gets errors.
"undefined function rtrim in expression". What I am doing wrong?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top