Access 2000 Listbox border

[Guest]

Please help. I need to run a report that must have a combo box. End of
story. No other box types will do! Now this listbox is next to a text box
and when the report is run it goes something like this "54 new widgets were
made in 2005." The only thing is, is that the 54 comes from a listbox, and
the "new widgets were made in 2005" comes from a text box. Every time the
report is run it looks up a new value and puts it in the listbox. This works
great only one problem... the list box has a box around it, and it does not
look good on the report. So, now that I have searched the Net high, and low.
How do I reformat the border around the listbox.

Ah, I know what your thinking. Why use a list box just use a text box.
STOP RIGHT THERE! I want a listbox without a border, not a text box without
a border. I can already get rid of a text box border that is not why I am
asking for your help. Oh yea if you should try to tell me to us VBasic,
please spell it out for me as if I have never used VBasic before, because I
haven't. No do I even know how to get to those screens that contain Vbasic.

Thank you.

 

[Guest]

Click on the listbox in report design view and in the properties window, make
the border "transparent".

 

[Rick Brandt]

Please help. I need to run a report that must have a combo box. End of
story. No other box types will do! Now this listbox is next to a text box
and when the report is run it goes something like this "54 new widgets were
made in 2005." The only thing is, is that the 54 comes from a listbox, and
the "new widgets were made in 2005" comes from a text box. Every time the
report is run it looks up a new value and puts it in the listbox. This works
great only one problem... the list box has a box around it, and it does not
look good on the report. So, now that I have searched the Net high, and low.
How do I reformat the border around the listbox.

Ah, I know what your thinking. Why use a list box just use a text box.
STOP RIGHT THERE! I want a listbox without a border, not a text box without
a border. I can already get rid of a text box border that is not why I am
asking for your help. Oh yea if you should try to tell me to us VBasic,
please spell it out for me as if I have never used VBasic before, because I
haven't. No do I even know how to get to those screens that contain Vbasic.

People in hell want ice water. AFAIK the ListBox will always display in a
report with a box around it. I suppose you could try to place a white rectangle
around it such that the border is covered up, but frankly I have no idea if that
will work either.

Perhaps you should be less rigid in your thinking. There is absolutely no
reason why a report MUST have a ListBox in it.

 

[Guest]

Ok, I have a large database that has queries that tell me how many widgets
are entered at any given moment. I figured out how to use a listbox to
insert the amount of widgets in the middle of a sentence. I could use a text
box, but when I do it looks something like this "As of today you have in
stock." Now that is no help, a sentence that tells you nothing. When I
insert the list box I get a sentence that tells me something like. "As of
today you have 79 widgets in stock." Only there is a stupid box around the
number. When I go to design view, and properties I have a selection that
will let me make the border transparent and that is what is so frustrating.
If you give me an option to get rid of the borders, let me get rid of the
borders. END OF STORY. So obviously someone designed the listbox to get rid
of the borders. How do you do it, or how can I make a text box that will
always be equal to the listbox? Hey people in hell might want ice but if you
offer them ice, then give them ice!

 

[Guest]

Have you tried a textbox with a calculated control source? Try adding a new
textbox to the report. Name it something like txtStock. Enter the following
as the control source for the textbox:

="As of today you have " & Nz([Quantity],0) & " " & [ItemDesc] & " in stock."

where [Quantity] and [ItemDesc] are fields in the report's recordsource
(query or table) that include the number of items and the item description,
such as widgets.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Ok, I have a large database that has queries that tell me how many widgets
are entered at any given moment. I figured out how to use a listbox to
insert the amount of widgets in the middle of a sentence. I could use a text
box, but when I do it looks something like this "As of today you have in
stock." Now that is no help, a sentence that tells you nothing. When I
insert the list box I get a sentence that tells me something like. "As of
today you have 79 widgets in stock." Only there is a stupid box around the
number. When I go to design view, and properties I have a selection that
will let me make the border transparent and that is what is so frustrating.
If you give me an option to get rid of the borders, let me get rid of the
borders. END OF STORY. So obviously someone designed the listbox to get rid
of the borders. How do you do it, or how can I make a text box that will
always be equal to the listbox? Hey people in hell might want ice but if you
offer them ice, then give them ice!
__________________________________________

:

Please help. I need to run a report that must have a combo box. End of
story. No other box types will do! Now this listbox is next to a text box
and when the report is run it goes something like this "54 new widgets were
made in 2005." The only thing is, is that the 54 comes from a listbox, and
the "new widgets were made in 2005" comes from a text box. Every time the
report is run it looks up a new value and puts it in the listbox. This works
great only one problem... the list box has a box around it, and it does not
look good on the report. So, now that I have searched the Net high, and low.
How do I reformat the border around the listbox.

Ah, I know what your thinking. Why use a list box just use a text box.
STOP RIGHT THERE! I want a listbox without a border, not a text box without
a border. I can already get rid of a text box border that is not why I am
asking for your help. Oh yea if you should try to tell me to us VBasic,
please spell it out for me as if I have never used VBasic before, because I
haven't. No do I even know how to get to those screens that contain Vbasic.

People in hell want ice water. AFAIK the ListBox will always display in a
report with a box around it. I suppose you could try to place a white
rectangle
around it such that the border is covered up, but frankly I have no idea if
that
will work either.

Perhaps you should be less rigid in your thinking. There is absolutely no
reason why a report MUST have a ListBox in it.

 

[Guest]

To "Tom Wickerath"

Have you tried a textbox with a calculated control source? Try adding a new
textbox to the report. Name it something like txtStock. Enter the following
as the control source for the textbox:

="As of today you have " & Nz([Quantity],0) & " " & [ItemDesc] & " in stock."

where [Quantity] and [ItemDesc] are fields in the report's recordsource
(query or table) that include the number of items and the item description,
such as widgets.

..
Yes I just did. I cut your expression right off of this web page and where
[Quantity] was I clicked on my query, then field and they were inserted and
now Access wont accept that expression. I don’t need the item description
field I cut and pasted this right off the expression builder.

=Nz([Total 2005 Cases 2]![CountOfCASE #],0)

Query = Total 2005 Cases 2
Field = CountOfCase #

I don't know what Nz is, nor do I know what ,0 does.

Can you help any more? I don't know why I can get what I need to come up
every time in a list box and then when I try to do the same thing in a list
box I get #NAME? , nothing, or I am told it is a bad expression

 

[Guest]

Yes I just did. I cut your expression right off of this web page and where

[Quantity] was I clicked on my query, then field and they were inserted and
now Access wont accept that expression.

What I gave you was intended as the control source for a textbox in your
report. If I understand you correctly, you attempted to insert this
expression into a query?

I don’t need the item description field...

Is the item description always the same (ie. "widgets" in your earlier
post)? The reason I ask is that I hope you are not storing quantity and
description together in one field.

I don't know what Nz is, nor do I know what ,0 does.

Nz is a built-in function in Access which you can use to convert null to
just about anything you want. In the example I provided, if the field is
null, I am converting it to 0 (zero). The general format is:

Nz([FieldName], ValueIfNull)

The ValueIfNull can be numeric, like 0, or it can be a string value such as
"None".


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Yes I just did. I cut your expression right off of this web page and where
[Quantity] was I clicked on my query, then field and they were inserted and
now Access wont accept that expression. I don’t need the item description
field I cut and pasted this right off the expression builder.

=Nz([Total 2005 Cases 2]![CountOfCASE #],0)

Query = Total 2005 Cases 2
Field = CountOfCase #

I don't know what Nz is, nor do I know what ,0 does.

Can you help any more? I don't know why I can get what I need to come up
every time in a list box and then when I try to do the same thing in a list
box I get #NAME? , nothing, or I am told it is a bad expression