Replacing text...

[Jason.A.Oliver]

Hi everyone,
Does Access have a find/replace feature hidden somewhere? Almost every
other Windows program I've used has one, but I can't find one for
Access.

I'm creating forms with hundreds of variables and need the caption to
be different on the form than on the table. Long story short, if I
could do a find/replace to remove part of the text from the caption of
those labels, it would save me a lot of time, but I can't find one.

Similar problems with editing a table in design view...no find/replace
is making a very simple task into something incredibly long and
monotonous.

[Tom van Stiphout]

On 31 May 2006 10:16:54 -0700, Ja************@gmail.com wrote:

Nothing built-in. "Speed Ferret" and "Find and Replace" are two cheap
utilities that fill the gap.

-Tom.

Hi everyone,
Does Access have a find/replace feature hidden somewhere? Almost every
other Windows program I've used has one, but I can't find one for
Access.

I'm creating forms with hundreds of variables and need the caption to
be different on the form than on the table. Long story short, if I
could do a find/replace to remove part of the text from the caption of
those labels, it would save me a lot of time, but I can't find one.

Similar problems with editing a table in design view...no find/replace
is making a very simple task into something incredibly long and
monotonous.

[Arthur]

Hi,

you can export that form in a text file

Goto visual basic editor and press CTRL+G
then on the intermediate window type this.

SaveAsText acForm, "Form1", "C:\Form1.txt"

be sure to replace Form1 with the name of the form you want
to edit.Since it is already a text file you can use notepad-find and
replace.

After you have done editing you can import that text file
by using this.

LoadFromText acForm, "Form1", "C:\Form1.txt"

HTH

[w_a_n_n_a_l_l_ -]

When did SaveAsText/LoadFromText become available?

[John Mishefske]

w_a_n_n_a_l_l_ -@-_s_b_c_g_l_o_b_a_l._n_e_t wrote:

When did SaveAsText/LoadFromText become available?

The are hidden methods that have been available since at least A97 and probably before.
Not supported by Microsoft (that's why you won't find them in the on-line help) and
not guaranteed to be supported in future versions.

(Although they are in Access 2007 beta2)

--
'---------------
'John Mishefske
'---------------