Connecting Tech Pros Worldwide Forums | Help | Site Map

select which fields to display on a form

Laertes
Guest
 
Posts: n/a
#1: Nov 13 '05
HI,

is it there a possibility of selecting which fields to have visible on
a form?
Up to now I've setup another form which has true/false toggles (one
for each field in question) on which I select which fields I want
visible. Then when I open the form in question the "openform"
subroutine checks which toggles have true values and sets the visible
property of the corresponding fields to true. So far so good...BUT I
want to compact the form so not to have gaps where the invisible
fields are... Any ideas?

Otherwise is it possible to dynamically (if this the correct term)
create a form? i.e. create a temporary form each time you choose which
fields to display?

Or is it possible to control by code the "show" option of the fields
in a Query?

Thanks in Advance

Laertes

misscrf
Guest
 
Posts: n/a
#2: Nov 13 '05

re: select which fields to display on a form


I have done this in a matter of speaking. If your fields are
conditional this is pretty easy. Let's say that if one is to be shown,
another will always be not shown. Then put on on top of the other....

I did that and it looks great on the form side. Just have to know what
you are doing on design side.

Closed Thread