Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    austin, Texas, USA
    Thanked 0 Times in 0 Posts

    Change the default format on form fields (Access 2k, Win 2K Pro)

    I recall somewhere seeing a tip on this but can't remember or find the 'somewhere'. The question is, is there a way to tell access to use some other format for creating a form field when dragging the name from the field picker box in form design? Access defaults to having the lable at the left of the field; I'd like to have the lable at the top.

    <img src=/S/compute.gif border=0 alt=compute width=40 height=20>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Change the default format on form fields (Access 2k, Win 2K Pro)

    Open the form in design view.
    Click the Text box button on the Toolbox, but do not create a text box (yet).
    Any properties you set now will be the default value for text boxes on this form.
    The properties you need are LabelX and LabelY. On my system, they are set to -3cm and 0cm, i.e. 3 cm to the left of the text box. To place the label 0.5 inch above the text box, set LabelX to 0" and LabelY to -0.5".

Posting Permissions

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