want borderless listbox

[gwidijanto]

I have a form with listbox on it.
On formview the listbox has no border, but
when I print it out , the listbox always has a border (thin line box).
On Listbox properties, I did like this:
Special Effect = flat
Border style = transparent
Border with = hairline
What else should I look to eliminate the border?
Thank you for your help.

Gunawan.

 

[IMO]

Try changing the border colour to white.

IMO

 

[Fizzio]

Make the borderline white then transparent.

Better again, don't print the form, create a report and print that instead - you can get much better formatting that way.

 

[OneRandomStone]

That's True, especially if your End-User gets cocky - and wants to print out on blue paper!

 

[gwidijanto]

Hi Guys,
changed border line color same as background = white, didn't work, the line still there.
This line only appear in print preview, in form view no line and this is what I want!
Tried converting the form to report, same result, line still there (print preview)
Any other suggestion for me to try?
Thank's

Gunawan

 

[IMO]

Tried converting the form to report

Gunawan

Create a report that replicates your form, as Fizzio said.

IMO

 

[Idjit]

That's True, especially if your End-User gets cocky - and wants to print out on blue paper!

Does your printer have white ink, then?

 

[gwidijanto]

Hi Guys,
still have trouble with it.
I discovered all listbox I made, on print preview always has a border! Even if you don't see it on print preview, it will appear on the printed paper.
Do you ever notice this? Would you mind trying it using simple form to see if this is always happen like I got?
I print it from form and report, same result.

Thank you.

Gunawan.

 

[Idjit]

Gunawan,

I experimented a bit and found the same problem you had. I don't think you can get the look you want using a list box.

BUT, I don't think you want to use a list box for printing, and as the others have said it's better to use reports for printing than forms anyway. The problem with using a list box in the printed version is that you'll see all of the options in the box, and in the example I printed out the row that was selected in each case printed out in black so you couldn't read it anyway.

I would use a report for printing, and use a text box or dropdown field instead of a list box.

 

[gwidijanto]

Thank's for your response Idjit,
this problem also appear on report too! So, on form or report, if you use listbox and print it out, you will see the border line!
But it is not happen on textbox.
Idjit, do you know how to export listbox content (single column listbox) into textbox?
my listbox content is like this:
-. aaaaaa
-. bbbbbb
-. cccccccc
that content is records from field named XXX in table named YYY.

Or, how to pick that records and put it on the textbox with the same look as listbox above?

thank you in advance for your help.

Gunawan.

 

[HOTBETZ]

if u create a report
and then simply change from listbox to textbox, that just shows the desired record. Doesnt it???

 

[gwidijanto]

No,
if you simply change listbox to textbox, it will show up only 1 record at one time, what I need is to show up all 3 records at one time and with the same look as my example above.

Somebody can help me, please?