Place Fields In Particular Spot On Form

[Cindy]

Hi. Based on the machines I select, certain fields of entry are made
to be visible on a form. The problem is that I want them (the fields)
one right under the other but do not want any blank or empty spaces if
a field is not being used. It is easy enough to place one field on
top of the other and make it visible if need be, but there are quite a
few of them, and the same ten fields (for example) would have to be
put one right over the other _at each placeholder_ in the form. That
is quite cumbersome and not very practical. In short, is there any
way to simulate a "can grow"-type scenario with actual fields of
entry?

Thank you kindly,

Cindy

[Linq Adams via AccessMonster.com]

You understand, I hope, that there's not going to be an easy way to do this!

How many different combinations do you anticipate?

If I were trying to do this, I'd use a Tabbed Control, setting up a page for
each machine, with the textboxes needed for that particular machine, arranged
as you like.

After each page was set up, I'd select the Tabbed Control (make sure it's the
control itself, not one of the pages) and set its Style to "None." This will
remove the tabs from the top.

Either set the Visibility property for each page to No/False, or set all of
them to False except the page, if any, that shows all the textboxes,
whichever you prefer for cosmetic purposes.

When the machine is selected, set the Visibility for the appropriate page to
True.

You'll need to place the same code that decides which tabbed page is visible
in the Form's OnCurrent event as well.

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

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com