I have created an Access Report where some fields are based on combo boxes...created from tables (not lookup), using the Access Form (and therefor they are also shown as combo boxes in the Access Table and the Design View of the Report). The layout of the report requires some of the text from...
jfischer, Thanks. Maybe I am not describing my challenge sufficently. Here is what I get when I look at my Report in design view and bring up the Functions on what I called "text3, or text4, or text5" in the posting. (The texts are really ServiceAreaA, SAB, and SAC.)
Label on...
Thanks all. Got it to work just fine. Now I have another challenge...to to the same thing with a "Combo Box" selection in the report field. That is, that instead of text3, text4, and text5 being Text data fields, they are the result of selections from a Combo Box....
Report output...
Cityboy3. Thanks for quick response. Either I don't understand or it does not work. I went to text4 and text5, changed their properties Can Shrink to yes. I get:
text1 text2 text3
text1A text2A text3A
text4A
text1B text2B text3B...
My printed Access Report looks like this:
text1 text2 text3
text4
text5
(next record)
Text3, text4, and text5 line up under each other, but not in this posting.
Each of the text variables are in one table/one record and input via an...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.