Moving text boxes on a form

[Guest]

Hi All,

I have a continuous form with about 30 text/combo/check boxes going across
the form, depending on the type of user, certain boxes are 'Visible = False',
which means the user sees some boxes and a bunch of gaps. Is there a way to
have the visible boxes and the labels (which are in the header and therefore
not attached) move to the left so the form looks better. The visible boxes
are different for each user and i need a small gap between each one as my
users prefer this.

Thanks
Emma

 

[Rob Oldfield]

Think it should be possible by doing something like....

select case UserType()
case "Admins"
me.ctl1.visible=true
me.ctl1.left=47
me.ctl2.visible=true
me.ctl2.left=83
case "PeopleIReallyDoNotTrust"
me.ctl1.visible=false
me.ctl2.visible=true
me.ctl2.left=47
me.ctl2.enabled=false
me.ctl2.locked=true
end select