Report views

[Very Basic User]

Hello,

I have a few items in my form that are drop down selection items from a
value list. When I created the report, it shows all items in my list and
highlights the one I've selected. Is there a simple way to just have the
report show my selection only.

 

[S.Clark]

I assume that you are printing a form, and not a report. If that is the
case, there is a property called 'Display When' that allows you to show/hide
a control during screen view / printing. You could create a text box
control, that shows only during printing, which displays the value from the
'drop down selection items'.

 

[Maarkr]

did you made the list as a lookup in the table? if so, read this...

http://www.mvps.org/access/lookupfields.htm

you may be able to fix it by right clicking the field in design mode and
changing it to a text box if it wrote to your table correctly... respond if
that doesn't do it and let us know what u see.

 

[John W. Vinson]

Hello,

I have a few items in my form that are drop down selection items from a
value list. When I created the report, it shows all items in my list and
highlights the one I've selected. Is there a simple way to just have the
report show my selection only.

Base the Report, not on your table, but on a Query joining the table to the
rowsources of the combo boxes; and use a textbox bound to the lookup tables'
text fields instead of a combo box.