Report formatting won't work

B

b_lwalker

For some bizarre reason my combo boxes aren't formatting on my report.

I have a couple of combo boxes using summed queries that will not hold
a format (e.g. "Standard"). The annoying thing is that this very same
thing works just fine on other reports I've done. I'm stuck and any
clues would be appreciated.

Cheers
 
J

John W. Vinson

For some bizarre reason my combo boxes aren't formatting on my report.
Click to expand...

Why would you want to put a combo on a report!!?

Just base the Report on a query joining your main table to the lookup tables,
and display the lookup text field in a textbox.

John W. Vinson [MVP]
 
B

b_lwalker

Why would you want to put a combo on a report!!?
Just base the Report on a query joining your main table to the lookup tables,
and display the lookup text field in a textbox.

John W. Vinson [MVP]
Click to expand...

Thank you John for your repsonse - I was having trouble getting my
head in the right space to figure out this report and you gave me the
jolt I needed. Turned out I needed 5 sub queries in order to get the
report working - but it now works!

As far as using combo boxes on reports - in some situations I find it
easier to do that than to try and work what I need into the main
query.

Cheers,

Bruce Walker
 
Top