Text loading as numbers

[#1]

Hi,

I have a table in access database with column cameraname and this column contains character(text) adat. When I am loading this table the character data is loading as numbers. can anyone let me know please what is this strange behaviour.

Thanks.

[nelsoncarmo]

I'm using

num( Field,   '#####################')

where ##################### is the same qty of number of digits.

Try this.

Nelson

[sri_c003]

Still no use.

Using the below in chart where vTopSales could be any number like 4565675737.

dual(text('$' & Num($(vTop5Sales),'################')), $(vTop5Sales))

Instead of showing as string, it is still getting treated as a number on display.