W
Walter
I cannot get the Trim fuction working in Access2000.
The error message is;
Undefined Function Trim in Expression.
Here is the SQL
UPDATE tblProducts SET tblProducts.ProductID = Trim
([tblProducts]![ProductNbr]);
Both fields are of type text and 50 charactters long.
The same problem occurs for some other text functions. I
have reinstalled office but this does not seem to help.
Does anyone have any ideas?
Walter
The error message is;
Undefined Function Trim in Expression.
Here is the SQL
UPDATE tblProducts SET tblProducts.ProductID = Trim
([tblProducts]![ProductNbr]);
Both fields are of type text and 50 charactters long.
The same problem occurs for some other text functions. I
have reinstalled office but this does not seem to help.
Does anyone have any ideas?
Walter