HOW TO COUNT characters in field

  • Thread starter Thread starter DK
  • Start date Start date
D

DK

I need to extract number of caracters in field.

Something as if number of characters in field "Field 1" = 13 then do this
else do this.

Thank You for Your help


DK
 
Use built-in function Len(), like

If Len([ControlName]) = 13 Then ...

HTH,
Nikos
 

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

Similar Threads

Filling the field in form 1
To set display format 2
Count string occurrences 9
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
character count in form 2
Split data in field on character return 0
Access Dcount (multiple criteria) 3
Aligning fields in combo box expression 4

Back
Top