Is it possible to query on a field for records that have a hard return?
P Programmer - wannaB Jan 31, 2008 #1 Is it possible to query on a field for records that have a hard return?
F fredg Jan 31, 2008 #2 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) & "*"
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) & "*"
P Programmer - wannaB Jan 31, 2008 #3 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...
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...
