dragging fields in design form view

24 Feb 2005 2:06 PM

Rasoul Khoshravan Azar

I am using an Asian right-to-left language. So I prefer that labels for
fields appear in right and data boxes appear in left.
When I drag fields from field list to form design page, lables appear in
left and data box in right which is an English format. Is it possible to
change the settings so that they appear in reverse the order?
Now I reverse the order manually for each field by many draggings !?!
There is a command in Tools/options/Right-to-left tab/Default direction and
I changed it but didn't help to my problem.

TIA
Rasoul Khoshravan Azar

24 Feb 2005 5:30 PM

Joan Wild

Rasoul Khoshravan Azar wrote:

> I am using an Asian right-to-left language. So I prefer that labels
> for fields appear in right and data boxes appear in left.

Open a form in design view. Click on the textbox button on the toolbox.
Then click on the properties button.

The properties displayed are the defaults for the textbox control. On the
format tab, change the settings for Label X. It likely says -1"
or -2.5cm. Change this to 2" or 5cm (play with it a bit until you get what
you want).

--
Joan Wild
Microsoft Access MVP

25 Feb 2005 1:43 PM

Rasoul Khoshravan Azar

Dear Joan
Thanks alot. It worked as I wanted. I figured out that when I make number
bigger the lable and text box get away from each other and when decrease the
number, they become closer to eachother. In case of label Y value, it is
easy to understand that it is the vertical distance between lable and text
box but could you kindly tell what exactly this number (2") is controlling
for lable X?
Thanks again
Rasoul

Show quote

"Joan Wild" <jwild@nospamtyenet.com> wrote in message
news:e09OMapGFHA.2132@TK2MSFTNGP14.phx.gbl...
> Rasoul Khoshravan Azar wrote:
> > I am using an Asian right-to-left language. So I prefer that labels
> > for fields appear in right and data boxes appear in left.
>
> Open a form in design view. Click on the textbox button on the toolbox.
> Then click on the properties button.
>
> The properties displayed are the defaults for the textbox control. On the
> format tab, change the settings for Label X. It likely says -1"
> or -2.5cm. Change this to 2" or 5cm (play with it a bit until you get
what
> you want).
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
>

25 Feb 2005 4:55 PM

Joan Wild

Rasoul Khoshravan Azar wrote:

> Dear Joan
> Thanks alot. It worked as I wanted. I figured out that when I make
> number bigger the lable and text box get away from each other and
> when decrease the number, they become closer to eachother. In case of
> label Y value, it is easy to understand that it is the vertical
> distance between lable and text box but could you kindly tell what
> exactly this number (2") is controlling for lable X?

It is the distance from the upper left of the textbox control the label is
attached to. Once you have the properties box shown for this default
textbox, you can click in any property and hit F1 for help/explanation.

--
Joan Wild
Microsoft Access MVP