Listbox: Borders won't go away, Reappear when Printing

M

Millard

I thought I would share a solution I've found for a problem. I have
some list boxes that I want to be borderless. The display fine, but
when Access 2003 prints, the list boxes sudden have very thin borders.

Nothing will remove these borders. I looked this up in the groups and
found a similar question in 2002 in a post titled:
report w/ listbox --> can you make the border go away?

I am unable to respond to an old post, so I wanted to share what I
found. The borders seem to appear in printing when your list box has
more than one column. I think the list boxes are trying to display
column boundaries, effectively creating a border when you don't want
one.

My solution was to catenate the display elements in the columns,
reducing the number of columns down to one. Once I only had one column,
the problem went away.

I hope this helps someone in the future!
 
D

Douglas J Steele

Listboxes only exist on forms, and forms aren't intended for printing:
that's what reports are for.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top