Report formatting won't work

[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

 

[John W. Vinson]

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

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_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]

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