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
 
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

How to create a VBA function which can be used within a query 11
Pattern Matching ..Waterfall Logic ... Table Logic? 2
Pattern Match 19
Pattern Matching in Excel 2007 1
Find a Pattern and Parse Text 7
Pattern matching in VB code? 2
Problem with Median Calculation / VBA Script 2
Searching in VBA like the find function 3

Back
Top