>> Visible and not visible

[Jonathan]

Hi, using Access 2003. I have 2 groups of controls on a form. Based upon user
selection either one or both groups of controls may be visible. Layout
options are
1. one group next to the other group. Visually it looks strange if only the
right side group are visible (ok when only left side group visible).
2. one group below the other group. Visually it looks strange if only one
group are visible (ok when both groups visible).

Is there a way to close the gap when only one group of controls are visible?

Any ideas or suggestions appreciated

Many thanks,
Jonathan

 

[Jeanette Cunningham]

Johathan,
you can write code to move controls depending on the value of the user
You move a control up or down the form by setting its Top property
Me.txt1.Top = 4 * 567
You move it left or right by setting its Left property
Me.txt1.Left = 2.65 * 567

In Australia *567 converts twips to centimetres.
I forget what is for inches.

You can also use logic like this:
If me Usuer = somevalue then
Me.txt1.Top = Me.txt1.Top + 2 * 567
Else
End If

Jeanette Cunningham

 

[Jeanette Cunningham]

Oops,
put brackets around the calculations on this line:

Me.txt1.Top = Me.txt1.Top + (2 * 567)

Jeanette Cunningham

 

[Linq Adams via AccessMonster.com]

In the "English" speaking part of the world it would be 1440 twips/inch!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com