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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top