Number of Characters in a cell

P

PurdueNate

Hello,

I am trying to find a function that will return the number of characters in
a cell.

Examples

12412 would return a value of 5
3460347 would return value of 7
89 would return a value of 2

Does this function exist? If not, is there an easy little statement that
can be written to cover it?

Thanks,
PurdueNate
Access Newbie
 
D

Douglas J. Steele

With text, there's the Len function. To use it with a number, you'd need to
convert it to a string first:

Len(Cstr(Number))
 
Top