Default size, label etc on new controls

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • JustJim
    Recognized Expert Contributor
    • May 2007
    • 407

    Default size, label etc on new controls

    Hi all,

    My new assignment again involves someone else's database application - why do I get all the trouble-shooting jobs and never get to build from scratch?

    When I drag a fieldname from the Field List to the design view of a report or form, the control placed:

    A) has no label and
    B) has a font size larger than I wish

    I suspect that the previous designer set this up deliberately but I can't remember/find where to change these defaults.

    Any help would be appreciated.

    Thanks

    Jim
  • ADezii
    Recognized Expert Expert
    • Apr 2006
    • 8834

    #2
    Originally posted by JustJim
    Hi all,

    My new assignment again involves someone else's database application - why do I get all the trouble-shooting jobs and never get to build from scratch?

    When I drag a fieldname from the Field List to the design view of a report or form, the control placed:

    A) has no label and
    B) has a font size larger than I wish

    I suspect that the previous designer set this up deliberately but I can't remember/find where to change these defaults.

    Any help would be appreciated.

    Thanks

    Jim
    It seems what you have to do is to modify the Properties for a 'Default Text Box' and here is how you accomplish this:
    1. In Form Design View
    2. Select View from the Menu Bar ==> Toolbox
    3. Select the Text Box Object (Single Click)
    4. Select View from the Menu Bar ==> Properties
    5. Notice the Title in this Dialog Box (Default Text Box)
    6. This is where you set the Default Properties for newly created Text Boxes
    7. Set Auto Label = Yes to automatically generate an attached Label for newly created Text Boxes
    8. Adjust the Font Name, Size, Weight, etc. to establish Default Properties for new Text Boxes
    9. Good Luck

    Comment

    • JustJim
      Recognized Expert Contributor
      • May 2007
      • 407

      #3
      Originally posted by ADezii
      It seems what you have to do is to modify the Properties for a 'Default Text Box' and here is how you accomplish this:
      1. In Form Design View
      2. Select View from the Menu Bar ==> Toolbox
      3. Select the Text Box Object (Single Click)
      4. Select View from the Menu Bar ==> Properties
      5. Notice the Title in this Dialog Box (Default Text Box)
      6. This is where you set the Default Properties for newly created Text Boxes
      7. Set Auto Label = Yes to automatically generate an attached Label for newly created Text Boxes
      8. Adjust the Font Name, Size, Weight, etc. to establish Default Properties for new Text Boxes
      9. Good Luck
      Cheers,
      That will help me and it's a handy thing to have on the forum anyway.

      Thank you

      Jim

      Comment

      • ADezii
        Recognized Expert Expert
        • Apr 2006
        • 8834

        #4
        Originally posted by JustJim
        Cheers,
        That will help me and it's a handy thing to have on the forum anyway.

        Thank you

        Jim
        You are quite welcome, Jim.

        Comment

        • missinglinq
          Recognized Expert Specialist
          • Nov 2006
          • 3533

          #5
          Don't you just hate cleaning up after someone else?

          The kicker is, that, for an existing database, you have to do this for each form! There's no way (at least thru ACC2003) to do this for the entire database at one go.

          For a new db, or for new forms on an existing one, you can design a form, with formatted default controls, and then use that as a template for all forms!

          Good luck!

          Linq ;)>

          Comment

          • ADezii
            Recognized Expert Expert
            • Apr 2006
            • 8834

            #6
            Originally posted by missinglinq
            Don't you just hate cleaning up after someone else?

            The kicker is, that, for an existing database, you have to do this for each form! There's no way (at least thru ACC2003) to do this for the entire database at one go.

            For a new db, or for new forms on an existing one, you can design a form, with formatted default controls, and then use that as a template for all forms!

            Good luck!

            Linq ;)>
            Don't you just hate cleaning up after someone else?
            Hey linq, isn't that why they call you the 'Cleaner'? (LOL).

            Comment

            • missinglinq
              Recognized Expert Specialist
              • Nov 2006
              • 3533

              #7
              They do? LOL!

              Just like JustJim, I hate to have to fix someone else's mistakes! In my experience, those mistakes were always made by someone who made wayyyyyyy more money than I did!

              Linq ;0)>

              Comment

              • JustJim
                Recognized Expert Contributor
                • May 2007
                • 407

                #8
                Originally posted by missinglinq
                They do? LOL!

                Just like JustJim, I hate to have to fix someone else's mistakes! In my experience, those mistakes were always made by someone who made wayyyyyyy more money than I did!

                Linq ;0)>
                Wow, what a can of worms! This assignment is particularly fun because it has been worked on by several people of different abilities and concepts. I've got code that (I think) never gets executed, front end and back end both on every user's C:\ drive and filters that get executed by passing secret code-words in the control.tag.

                The office is on the 12th floor, but fortunately the windows don't open.

                Back to work.

                Jim

                Comment

                Working...