Printing forms

O

o.sroubek

Once a form is ready for printing and was created with
for ex a combo box or list box, is it possible to have
the final print not showing the arrow and the box and
just the information chosen inside the box?
 
J

JE McGimpsey

o.sroubek said:
Once a form is ready for printing and was created with
for ex a combo box or list box, is it possible to have
the final print not showing the arrow and the box and
just the information chosen inside the box?
Click to expand...

One way (well, a workaround really):

Assume your input range is named input_range, your cell link is named
cell_link. Then in the cell *under* the combobox enter

=INDEX(input_range,cell_link)

and set the combobox not to print (Format/Control/Properties, uncheck
the print checkbox).
 
O

o.sroubek

Thanks. It sound kind of complicated. I'm not too
familiar with this program. I had done something similar
in Word using form fields and drop down boxes. The shaded
fields would not get printed, only what was selected.
Thank you
-----Original Message-----


One way (well, a workaround really):

Assume your input range is named input_range, your cell link is named
cell_link. Then in the cell *under* the combobox enter

=INDEX(input_range,cell_link)

and set the combobox not to print
Click to expand...
(Format/Control/Properties, uncheck
 
J

JE McGimpsey

o.sroubek said:
Thanks. It sound kind of complicated. I'm not too
familiar with this program. I had done something similar
in Word using form fields and drop down boxes. The shaded
fields would not get printed, only what was selected.
Click to expand...

It's really not that complicated: You already have a combobox,
presumably with an inputrange and a linked cell. What I suggested
involves

a) one additional formula, and

b) unchecking one checkbox in the Format/Control/Properties tab.

Form fields in Word are much more difficult (at least for me...)
 
Top