Hello,

Hope someone can help me with what is probably a reason easy problem, but 
is causing me enormous grief!  :-)

I'm developing a report in an Access 2000 database that amongst the label 
and text box controls, also holds a number of list boxes.  The list boxes 
work fine, except for one thing - no matter what values I give the border 
properties there is always a line around the list box when I print.  Very 
unsightly!

Is there a way around this?

Thanks,

Karen.

Karen,

<< I'm developing a report in an Access 2000 database that amongst the 
label and text box controls, also holds a number of list boxes.  The list 
boxes work fine, except for one thing - no matter what values I give the 
border properties there is always a line around the list box when I 
print.  Very unsightly! >>

If you say you changed the listbox's border property to "Transparent" and 
it still appears, I suggest just getting rid of the listbox and turning it 
into a textbox.

Actually, I'm confused why a report would even have a listbox.  If you 
have a choice to make about something, that should be done on the form.  
The report merely prints the form parameters after you have made all of 
your selections on the form.  There should be no user interaction with a 
report.

Greg

Greg,

Thankyou for you reply.  I used list boxes because I needed to print one 
or more rows for a particular product id (each report is based on a 
product), and I didn't know how to show one or more rows in a text box (it 
just shows one).  Is there a way?

Thanks,
Karen.




> Karen,

> << I'm developing a report in an Access 2000 database that amongst the 
l> abel and text box controls, also holds a number of list boxes.  The 
list 
b> oxes work fine, except for one thing - no matter what values I give the 
b> order properties there is always a line around the list box when I 
p> rint.  Very unsightly! >>

> If you say you changed the listbox's border property to "Transparent" 
and 
i> t still appears, I suggest just getting rid of the listbox and turning 
it 
i> nto a textbox.

> Actually, I'm confused why a report would even have a listbox.  If you 
h> ave a choice to make about something, that should be done on the form.  
T> he report merely prints the form parameters after you have made all of 
y> our selections on the form.  There should be no user interaction with a 
r> eport.

> Greg

Set the text box property of Can Grow to Yes.

HTH,

Beth 

-----Original Message-----
From: KAREN MARTIN [mailto:karen_a_martin@h...] 
Sent: Wednesday, March 12, 2003 2:43 PM
To: Access
Subject: [access] Re: List Control in Report Problem

Greg,

Thankyou for you reply.  I used list boxes because I needed to print one 
or more rows for a particular product id (each report is based on a 
product), and I didn't know how to show one or more rows in a text box (it 
just shows one).  Is there a way?

Thanks,
Karen.




> Karen,

> << I'm developing a report in an Access 2000 database that amongst the 
l> abel and text box controls, also holds a number of list boxes.  The 
list 
b> oxes work fine, except for one thing - no matter what values I give the 
b> order properties there is always a line around the list box when I 
p> rint.  Very unsightly! >>

> If you say you changed the listbox's border property to "Transparent" 
and 
i> t still appears, I suggest just getting rid of the listbox and turning 
it 
i> nto a textbox.

> Actually, I'm confused why a report would even have a listbox.  If you 
h> ave a choice to make about something, that should be done on the form.  
T> he report merely prints the form parameters after you have made all of 
y> our selections on the form.  There should be no user interaction with a 
r> eport.

> Greg

Karen,

<< Thank you for you reply.  I used list boxes because I needed to print 
one or more rows for a particular product id (each report is based on a 
product), and I didn't know how to show one or more rows in a text box (it 
just shows one).  Is there a way? >>

You're quite welcome.

You can set the textbox Can Grow property to YES.  If there is a one-to-
many relationship between Product ID and some other field, consider 
putting a subreport in the main report.  The subreport would be in tabular 
format and set its Can Grow property to YES.  Make sure the master and 
child fields are linked.

Greg

You could try using subforms instead of list boxes.

Bill Findlay

>>> SerranoG@m... 03/12/03 06:07pm >>>
Karen,

<< I'm developing a report in an Access 2000 database that amongst the
label and text box controls, also holds a number of list boxes.  The 
list
boxes work fine, except for one thing - no matter what values I give 
the
border properties there is always a line around the list box when I
print.  Very unsightly! >>

If you say you changed the listbox's border property to "Transparent" 
and
it still appears, I suggest just getting rid of the listbox and turning 
it
into a textbox.

Actually, I'm confused why a report would even have a listbox.  If you
have a choice to make about something, that should be done on the form. 

The report merely prints the form parameters after you have made all of
your selections on the form.  There should be no user interaction with 
a
report.

Greg

Hello!

I would like to thank everyone who replied about my list box problem.  I 
shall give all your suggestions a go tomorrow (have been away so have not 
been able to view my messages til now - apologies!).

I would like to ask the experts out there another question that I'm having 
a problem on, if thats ok.

I have a form that is bound to a table that lists all the product ids and 
product names and a report that is bound to a query that provides all the 
information for each product.  I am trying and failing miserably to link 
both the form and report.  So, that when the form is opened a user can go 
through all the products and when the right one has been selected, click 
on a button to open up the report to just show details on the selected 
product.

I just can't seem to get it.  I don't really want to get the user to type 
in a parameter value (such as the product id) having already made the 
selection, but that is so far the result of my work.

Can anyone please help.  I just can't get the coding right, and there does 
not seem to be the relevant help within Access Help itself.

Many thanks,
Karen.

You might want to try and create a combo box, with the row source having the
product id and description field. Then have a button with the On Click
event:

DoCmd.OpenReport "report name", acViewPreview, , "[product_id] = '" &
Me![cbo_product_id] & "'"

Hope this helps,
Curtis

-----Original Message-----
From: KAREN MARTIN [mailto:karen_a_martin@h...]
Sent: Thursday, March 20, 2003 8:18 PM
To: Access
Subject: [access] Re: List Control in Report Problem


Hello!

I would like to thank everyone who replied about my list box problem.  I
shall give all your suggestions a go tomorrow (have been away so have not
been able to view my messages til now - apologies!).

I would like to ask the experts out there another question that I'm having
a problem on, if thats ok.

I have a form that is bound to a table that lists all the product ids and
product names and a report that is bound to a query that provides all the
information for each product.  I am trying and failing miserably to link
both the form and report.  So, that when the form is opened a user can go
through all the products and when the right one has been selected, click
on a button to open up the report to just show details on the selected
product.

I just can't seem to get it.  I don't really want to get the user to type
in a parameter value (such as the product id) having already made the
selection, but that is so far the result of my work.

Can anyone please help.  I just can't get the coding right, and there does
not seem to be the relevant help within Access Help itself.

Many thanks,
Karen.

Hello everyone!

I've followed everyone's suggestions and I'm now happy to say that I've 
got a form with a combo (linked to a table) showing products that when one 
is selected opens up a report (linked to a query) to show the product's 
details (thankyou Curtis - much appreciated!).  This report has subreports 
that do not have the box surround when printed off (thanking everyone else 
here who replied to my problem)!

Just one thing.  (I know - there always is! :-)  ).  The subreports (a new 
concept to me) are linked to the same query as the parent report.  Of 
course, when I've selected the product and the report opens all of the 
fields provide the filtered details.  However, the subreports do not.  
They are not filtered and provide data on the whole linked query and not 
just the product in question.  So, I get pages of unrelated data.

Can anyone point me in the right direction?

Thanks,
Karen.




> You might want to try and create a combo box, with the row source having 
the
product id and description field. Then have a button with the On Click
event:

DoCmd.OpenReport "report name", acViewPreview, , "[product_id] = '" &
Me![cbo_product_id] & "'"

Hope this helps,
Curtis

-----Original Message-----
From: KAREN MARTIN [mailto:karen_a_martin@h...]
Sent: Thursday, March 20, 2003 8:18 PM
To: Access
Subject: [access] Re: List Control in Report Problem


Hello!

I would like to thank everyone who replied about my list box problem.  I
shall give all your suggestions a go tomorrow (have been away so have not
been able to view my messages til now - apologies!).

I would like to ask the experts out there another question that I'm having
a problem on, if thats ok.

I have a form that is bound to a table that lists all the product ids and
product names and a report that is bound to a query that provides all the
information for each product.  I am trying and failing miserably to link
both the form and report.  So, that when the form is opened a user can go
through all the products and when the right one has been selected, click
on a button to open up the report to just show details on the selected
product.

I just can't seem to get it.  I don't really want to get the user to type
in a parameter value (such as the product id) having already made the
selection, but that is so far the result of my work.

Can anyone please help.  I just can't get the coding right, and there does
not seem to be the relevant help within Access Help itself.

Many thanks,
Karen.

First mnake sure there is primary key /foreign key on the two reports.
Then select the proerties of the subreport and look for the parent and child
properties

Steve K


-----Original Message-----
From: KAREN MARTIN [mailto:karen_a_martin@h...]
Sent: 24 March 2003 20:59
To: Access
Subject: [access] Re: List Control in Report Problem



Hello everyone!

I've followed everyone's suggestions and I'm now happy to say that I've
got a form with a combo (linked to a table) showing products that when one
is selected opens up a report (linked to a query) to show the product's
details (thankyou Curtis - much appreciated!).  This report has subreports
that do not have the box surround when printed off (thanking everyone else
here who replied to my problem)!

Just one thing.  (I know - there always is! :-)  ).  The subreports (a new
concept to me) are linked to the same query as the parent report.  Of
course, when I've selected the product and the report opens all of the
fields provide the filtered details.  However, the subreports do not.
They are not filtered and provide data on the whole linked query and not
just the product in question.  So, I get pages of unrelated data.

Can anyone point me in the right direction?

Thanks,
Karen.




> You might want to try and create a combo box, with the row source having
the
product id and description field. Then have a button with the On Click
event:

DoCmd.OpenReport "report name", acViewPreview, , "[product_id] = '" &
Me![cbo_product_id] & "'"

Hope this helps,
Curtis

-----Original Message-----
From: KAREN MARTIN [mailto:karen_a_martin@h...]
Sent: Thursday, March 20, 2003 8:18 PM
To: Access
Subject: [access] Re: List Control in Report Problem


Hello!

I would like to thank everyone who replied about my list box problem.  I
shall give all your suggestions a go tomorrow (have been away so have not
been able to view my messages til now - apologies!).

I would like to ask the experts out there another question that I'm having
a problem on, if thats ok.

I have a form that is bound to a table that lists all the product ids and
product names and a report that is bound to a query that provides all the
information for each product.  I am trying and failing miserably to link
both the form and report.  So, that when the form is opened a user can go
through all the products and when the right one has been selected, click
on a button to open up the report to just show details on the selected
product.

I just can't seem to get it.  I don't really want to get the user to type
in a parameter value (such as the product id) having already made the
selection, but that is so far the result of my work.

Can anyone please help.  I just can't get the coding right, and there does
not seem to be the relevant help within Access Help itself.

Many thanks,
Karen.