access 2007

[radcliffe287]

I am trying to print a report, and have (at least) 2 problems:

1 The original datasheet has a field which is derived from a combo box (a look-up list with some 20 ewntries). I only want to show and print the selected entry for each record, but the report shows as many entries as it can fit in the multiple lines for each record (see my second problem below), with the correct entry shown in an inverted font (white on black), and the non-selected entries shown black on white. As well as confusing readers, this doesn't print clearly.

2 To get each record onto just one line (and thus get more records onto each page, I'd like to truncate some fields, but when I narrow the column in Layout View, the field is wrapped onto 2 or more lines, thwarting my efforts!.

I'm sure both these issues can be corrected on the Properties Tab, but have no idea how to do so. All suggestions greatly swelcomed!!

 

[KenHigg]

1. Are you trying to print a combo box on a report?

2. I try to set my sum of text box control widths to the the page width minus the margins...

 

[radcliffe287]

Thanks for replying.

1. Yes I am trying to print the selected value of the combo only - but some of the other adjacent values appear too.

Don't understand your 2nd question, though.