Pattern matching in VBA Find...

  • Thread starter Thread starter Rajat
  • Start date Start date
R

Rajat

Hi,

I'd like to be able to change all fieldnames referenced in
my form in the following ways:

1. Spaces to underscores
2. Mixed case to upper case

What pattern would I enter into the Edit>Find... command
in order to return all Fieldname references?

I tried [* *] to return fieldnames with spaces surrounded
by square brackets but it didn't work.

Thanks,

Rajat
 
to start with i wouldn't rely on edit -> find ;-)
hint: use strcomp & instr functions in VBA code with vbCompareBinary

hth

Pieter
 
Back
Top