Border around listbox

[tjcinnamon]

I searched the forum and only found something kind of relating to what my issue is. I have a report which contains a list box there is a border around it, I have set the border style to transparent and it won't disappear. Is there any way I can just have the data displayed with no border?

Ideas and Solutions Appreciated,
JOe K.

 

[rainman89]

change it to a text box by right clicking then change to text box. you can set the properties of the text box border to transparent

 

[tjcinnamon]

I actually need to keep it a list box, I have to display an indeterminate amount of columns in the header. I tried with a text box but can't get the textbox to display all of the values it will only display one of them.

 

[rainman89]

Thats because the report shows the value that u selected and that is stored in the table

 

[tjcinnamon]

It's referencing a query of cost allocations, so if I buy 3 $1 items and 2 goto Consumable Tools, and 1 goes to Small Hand Tools, How do I get it to display $2.00 Consumable Tools and $1.00 Small Hand Tools through a text box? There could be any number of cost allocations: Reg Mat, H&S Mat, H&S Cont, Consumable Tools ect. This has to be displayed in the header, I have the queries that get these individual totals and allocations, I just don't know how to display them without the border.

Thanks for your help so far,
JOe K.

 

[pbaldy]

I just tested and a listbox with the style set to transparent did not show a border. Make sure the special effect property is "Flat". The others may show a border.

 

[tjcinnamon]

I made sure the special effect property is "Flat", still no change.

 

[pbaldy]

Can you post a sample? As I said, when I test I get no border.

 

[tjcinnamon]

Here is the DB, press F10 to open the report.

Thanks for you time,
JOe K.

View attachment PO Database2k3.zip

 

[pbaldy]

Should have mentioned I only have A2k here. I have 2003 at home, and I'll be there in a bit, so I can check it then.

 

[tjcinnamon]

I'll post a A2K copy.

View attachment PO.zip

here

 

[pbaldy]

That is strange. I have a project I have to finish up, but I'll try to look at this later.

 

[tjcinnamon]

Have you found anything?

 

[rainman89]

I noticed that changing the border on the box(ie dot dot dash etc) doesnt change how it looks in the print preview... Also changing it to white doesnt either.this probably means its not dependent on the box but its controlled somewhere else..
was this a preset report design? or did u design this yourself?

 

[rainman89]

Figured it out. in your report setup u have print data only clicked. turn that off and ur boxes will disappear!

 

[tjcinnamon]

are you refering to the page set up?

 

[rainman89]

yes i am ............

 

[tjcinnamon]

if so, I just turned off the print data only and it disappeared for a one record. The next time I went to a different record the same problem happened again. Another weird thing I noticed was that if I move the box to different parts of the header the box borders will change randomly.

 

[rainman89]

Im not the best at vb but if there is a way for you to do the on_open of the report and set the page_setup.printdataonly(... or whatever it is )= no

then it should fix the problem for all the records.. again im not the best at vb so i cant write u the code nor am i sure taht there is even an option to allow for this

 

[tjcinnamon]

I can't figure out how to write that code. I tried this:

Private Sub Report_Open(Cancel As Integer)

DoCmd.RunCommand acCmdPageSetup

End Sub

But I get an error. I am not very good at coding either. Although I don't think this print data thing is the solution. I am willing to try anything at this point.

Thanks for your help so far,
JOe K.