I am trying to determine the length of a string. In the following:
'declared variables, set rs {recordset} to right table
do until rs.eof
price = rs!price
if len(price)....
etc.
loop
Access tells me that "Len(Price) = 8" when Price = "20"
I have tried trim function in case of spaces, as well as setting price to "20" manually, and it still says length of 8. Any ideas as to why this is happening?
'declared variables, set rs {recordset} to right table
do until rs.eof
price = rs!price
if len(price)....
etc.
loop
Access tells me that "Len(Price) = 8" when Price = "20"
I have tried trim function in case of spaces, as well as setting price to "20" manually, and it still says length of 8. Any ideas as to why this is happening?
