How to serach for hard returns in an MS Access table

[mcethier]

Hi,

I am working with a large Access database and need to ensure that there are no hard returns in any of the free text fileds prior to importing in SAS. Is there a way to serach for character that represents a hard return either by query or serach in a table? I hav enot been able to identify the symbol that represents a hard return in Access or Excel.

Thanks,
MC

 

[dhookom]

Typically you are looking for Chr(13) and/or Chr(10). Try set the criteria under the column to:

Like "*" & Chr(13) & Chr(10) & "*"

Duane
Hook'D on Access
MS Access MVP