By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,524 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Replacing text...

P: n/a
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.

May 31 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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.


May 31 '06 #2

P: n/a
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

May 31 '06 #3

P: n/a
When did SaveAsText/LoadFromText become available?
Jun 1 '06 #4

P: n/a
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
'---------------
Jun 1 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.