Count characters in a text field

[Harold M]

I am trying to count the number of characters in a text field.

For example, a credit card field may have 16 (Visa / MC), 15 (Amex), etc...
In some cases Visa may only have 13 characters. This does exclude any
hyphens.

Is there an easy way to do this?

Thank You

 

[Duane Hookom]

You can try Len(Replace([CardNum],"-",""))

 

[Harold M]

That's a very helpful tip but it wasn't what I was looking for. I was
trying to find out how to count the number of characters in a field. If a
field has "4435443244563422" I could have a query expression that returns a
16 for the number of characters.

You can try Len(Replace([CardNum],"-",""))

--
Duane Hookom
MS Access MVP

I am trying to count the number of characters in a text field.

For example, a credit card field may have 16 (Visa / MC), 15 (Amex), etc...
In some cases Visa may only have 13 characters. This does exclude any
hyphens.

Is there an easy way to do this?

Thank You

 

[Duane Hookom]

Did you try this? I did and the expression returned 16.

--
Duane Hookom
MS Access MVP

That's a very helpful tip but it wasn't what I was looking for. I was
trying to find out how to count the number of characters in a field. If a
field has "4435443244563422" I could have a query expression that returns a
16 for the number of characters.

You can try Len(Replace([CardNum],"-",""))

--
Duane Hookom
MS Access MVP

I am trying to count the number of characters in a text field.

For example, a credit card field may have 16 (Visa / MC), 15 (Amex), etc...
In some cases Visa may only have 13 characters. This does exclude any
hyphens.

Is there an easy way to do this?

Thank You