Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Newport, Gwent, Wales
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Form Format Question (Access 2k, win 2k)

    Hello again.

    I've been trying to find a way of changing the default text etc for the forms in Access. If it was Word or Excel I could do this simply but in Access I'm stuck. I can find the way of changing the default font in tables and queries etc but not for a form.

    Is it possible?

    If so where is the option hidden??? Please???

    This isn't a major hassle, but it would be nice if I didn't have to set up the form in rough, select all the objects and change them to the required font and size.

    Thanks for the help.

    Ian

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Form Format Question (Access 2k, win 2k)

    1. You can use Format | AutoFormat... to apply default settings to a form or report, or to a part of it. You can create your own AutoFormat settings by clicking Customize... in the AutoFormat dialog. If you create a form or report using a Wizard, the most recently used AutoFormat will be applied by default.

    2. You can use an existing form as template for new forms you create without the wizard. Select Tools | Options..., Forms/Reports tab, and enter the name of the existing form in 'Form template'. Similar for reports.

  3. #3
    3 Star Lounger
    Join Date
    Oct 2001
    Location
    Newport, Gwent, Wales
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form Format Question (Access 2k, win 2k)

    Hans

    Thanks. I followed both options in the end to get the desired result. First I created a form with the wizard and saved it, then put theat form into the Forms / Reports tab. My first attempt at just creating a form with all the objects on at my preferred font size didn't seem to work.


    Still, I no longer have to change the font size on all my objects, a small time saving per object but quite a while for a project, a happy chap I am. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    Ian

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •