Number of Characters in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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))
 
Back
Top