Results 1 to 2 of 2
2005-03-23, 14:42 #1
- 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>
2005-03-23, 14:53 #2
- Join Date
- Mar 2002
- Thanked 28 Times in 28 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".