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

Forms Format

P: n/a
JLM
I have 6 forms with mostly the same information. After creating them I'd
decided that I want them to all look alike, i.e., all like fields in the
same location, same size, etc.

Is there a way to accomplish this easily?

Thanks in advance,
jeff
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Open to the database window, right click on the form you want all other forms to
look like, click on Copy, move to a blank area of the database window, right
click and click on Paste. You now have a copy of the original form. Open the
form in design view, open properties and change the record source to the
appropriate table or query. Then go to each control on the form and change the
control source appropriately.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"JLM" <je**********@colostate.edu> wrote in message
news:40******@news.ColoState.EDU...
I have 6 forms with mostly the same information. After creating them I'd
decided that I want them to all look alike, i.e., all like fields in the
same location, same size, etc.

Is there a way to accomplish this easily?

Thanks in advance,
jeff

Nov 12 '05 #2

P: n/a
After creating the first form, go to Tools, Options, Forms/Reports and enter
the form name in the Form Template text box. From now on, all new forms
will start out with all formatting and other properties set to be the same
as the first form.

If the forms already exist, you probably should either set properties via
code or by hand.

Final option if you don't like the default system above, copy and paste one
form and rename it.

HTH
-Graham

"JLM" <je**********@colostate.edu> wrote in message
news:40******@news.ColoState.EDU...
I have 6 forms with mostly the same information. After creating them I'd
decided that I want them to all look alike, i.e., all like fields in the
same location, same size, etc.

Is there a way to accomplish this easily?

Thanks in advance,
jeff

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.