C
CAM
Hello,
I have a text field in my table call "ACICCTR" which contains numbers (i.e.
012 2273, 100 1172) in my report I need to pick up the last four digits I
use this code in my text box =" " & Right([ACICCTR],4) it works fine, but
when I convert this to excel I get (i.e. 012 -258315) it should be 012 2273
instead. The text box should be consider as TEXT not numeric Has anybody
ever had this problem before. Can anybody tell me how can I fixed this?
Any tips will be appreciated. I don't know how to format the text box as a
text. This is odd, because the field is a text. Thank you in advance.
Cheers
I have a text field in my table call "ACICCTR" which contains numbers (i.e.
012 2273, 100 1172) in my report I need to pick up the last four digits I
use this code in my text box =" " & Right([ACICCTR],4) it works fine, but
when I convert this to excel I get (i.e. 012 -258315) it should be 012 2273
instead. The text box should be consider as TEXT not numeric Has anybody
ever had this problem before. Can anybody tell me how can I fixed this?
Any tips will be appreciated. I don't know how to format the text box as a
text. This is odd, because the field is a text. Thank you in advance.
Cheers