P
Pwyd
I wanted to know, is there a way to attach a query to a textbox, or,
similarly, remove the scrollbars from a combo/listbox?
similarly, remove the scrollbars from a combo/listbox?
D
Duane Hookom
A text box displays a single value. Is your query a single field with a
single record? If a list box can display all items, I don't think there would
be a scroll bar. You might also be able to use a subform.
It would help if you provided more information about your requirements so we
don't have to make assumptions and guess.
single record? If a list box can display all items, I don't think there would
be a scroll bar. You might also be able to use a subform.
It would help if you provided more information about your requirements so we
don't have to make assumptions and guess.
P
Pwyd
It had one column, i'm having to add another. its a tiny thing, about an inch
by a third of an inch. it displays the two columns just fine, with plenty of
room to spare. but since its not really long, it insists on adding a
scrollbar on the bottom, unless i make the thing about 3 inches long, which
would be a giant waste of space.
I could use a subform, thats not a bad idea.
Will that substantially increase the amount of loading time and so on,
involved with the form?
also, will i have to change the subform's printing settings individually,
when they're added? Or will changing the parent form's settings do all of
that.
by a third of an inch. it displays the two columns just fine, with plenty of
room to spare. but since its not really long, it insists on adding a
scrollbar on the bottom, unless i make the thing about 3 inches long, which
would be a giant waste of space.
I could use a subform, thats not a bad idea.
Will that substantially increase the amount of loading time and so on,
involved with the form?
also, will i have to change the subform's printing settings individually,
when they're added? Or will changing the parent form's settings do all of
that.
D
Duane Hookom
The subform shouldn't have much effect on the performance.
I never recommend printing forms. That's generally the purpose of reports.
I never recommend printing forms. That's generally the purpose of reports.
P
Pwyd
I realize that, but i'm trying to keep things simple, so that they don't have
to do anything else in order to print out what they're looking at. I guess i
could open a hidden report form and print that ,but then its kind of
pointless isn't it?
to do anything else in order to print out what they're looking at. I guess i
could open a hidden report form and print that ,but then its kind of
pointless isn't it?
D
Duane Hookom
Creating a report only takes your time investment. You can drop a command
button on the form for the user to print the report. It doesn't get much
simpler for the user.
button on the form for the user to print the report. It doesn't get much
simpler for the user.
P
Pwyd
Right. But, as i've stated in other posts, i have no time. This isn't my
primary function. At any rate, There isn't anything i would change about how
its printing now, one record per page. shrug. It works in this case anyway
Thanks for your suggestion.
primary function. At any rate, There isn't anything i would change about how
its printing now, one record per page. shrug. It works in this case anyway
Thanks for your suggestion.
J
jlute
If you don't have the time now you could/should find time in the
future. Duane's direction is good - take it! Making a report and print
button will be worth the time/effort.
future. Duane's direction is good - take it! Making a report and print
button will be worth the time/effort.
P
Pwyd
To what end? it prints out just fine now. the form will never change. and by
never, i mean never.
never, i mean never.
D
Duane Hookom
If it "prints out just fine now" can we assume this is after fixing "remove
the scrollbars from a combo/listbox"?
There is an option in Access that allows you to save a form as a report.
the scrollbars from a combo/listbox"?
There is an option in Access that allows you to save a form as a report.
P
Pwyd
Not exactly. The subform settings still don't include turning off vert/horiz
scrollbars.
As for printing, its always printed correctly. Its not for presentation,
i've no desire for it to look "professional."
scrollbars.
As for printing, its always printed correctly. Its not for presentation,
i've no desire for it to look "professional."
D
Duane Hookom
You have lost me regarding what your original question/intention was. I don't
understand if the issue involved any printing or just viewing the
form/subform or whatever.
understand if the issue involved any printing or just viewing the
form/subform or whatever.
P
Pwyd
The issue, was trying to remove the scrollbars from a list/combo box. I
wanted to know if there was some other method for using a rowcontrol from any
of the available options, that could use a Query as the source, and display
the information without scrollbars, since they cannot be selectively turned
off for subforms or listboxes (or i dont know how).
wanted to know if there was some other method for using a rowcontrol from any
of the available options, that could use a Query as the source, and display
the information without scrollbars, since they cannot be selectively turned
off for subforms or listboxes (or i dont know how).