Text field

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

Guest

I have a text field in a form that may contain 20 characters. (e.g.,
PPPPTTTUPPPTUPPTTUPP). I need to know whow many "P" are in the field.
Please help...

Thanks,
 
As it happens, this came up in another thread recently. It seems a number of
people have come up with this solution independently of each other, so with
thanks to all of them ...

? len("PPPPTTTUPPPTUPPTTUPP")-len(replace("PPPPTTTUPPPTUPPTTUPP","P",""))
11
 
You must log in or register to reply here.

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

Validation Rule assistance 0
Access Access - Is it possible to repeat fields in a form? 1
Access Form - Lock Fields from Editing 0
Importing Text Files Into Access 1
Text Box Char Limit 5
Validate the number of checkboxes that can be true 0
memo field is limiting characters 1
3464 Data Type mismatch 4

Back
Top