MLH <CR**@NorthState.netwrote in
news:2u********************************@4ax.com:
Obviously, that was a guess.
Try it out & you'll see what happens -
or, rather, what does not happen.
Obviously?
From Access 97 Help
· When using wildcard characters to search for an asterisk (*), question
mark (?), number sign (#), opening bracket ([), or hyphen (-), you must
enclose the item you're searching for in brackets. For example, to search
for a question mark, type [?] in the Find dialog box. If you're searching
for a hyphen and other characters simultaneously, place the hyphen before
or after all the other characters inside the brackets. (However, if you
have an exclamation point (!) after the opening bracket, place the hyphen
after the exclamation point.) If you're searching for an exclamation point
(!) or closing bracket (]), you don't need to enclose it in brackets.
Obviously (note gentle irony rather than harsh sarcasm) you didn't read the
Help, didn't put any care into your test, and ignored fredg.
For what it's worth, on my test [?] found any question mark with or without
"Search Fields as Formatted" selected. However, my test table had no blanks
or Nulls.
I and perhaps others would be interested to know why your results differed.
DDB
(I'm much nicer than I sound.)