carriage return Query

  • Thread starter Thread starter Programmer - wannaB
  • Start date Start date
P

Programmer - wannaB

Is it possible to query on a field for records that have a hard return?
 
Is it possible to query on a field for records that have a hard return?
Click to expand...

As criteria on the field in question, write:
InStr([FieldName],chr(13) & chr(10))>0

or you could use:
Like "*" & chr(13) & chr(10) & "*"
 
Briliant simply briliant......
Thank you

fredg said:
Is it possible to query on a field for records that have a hard return?
Click to expand...

As criteria on the field in question, write:
InStr([FieldName],chr(13) & chr(10))>0

or you could use:
Like "*" & chr(13) & chr(10) & "*"
Click to expand...
 
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

Identify Carriage returns and line feeds on a table 3
Form recognizing hard carriage return 3
Split data in field on character return 0
Carriage return in memo field 5
Delete carriage returns 6
Need to Identify Records with Carriage Returns within a Memo Field 6
Remove Extra Carriage Returns 3
Query Parameter using multiple options 0

Back
Top