report conditional formatting (1 Viewer)

Dick7Access

Dick S
Local time
Today, 12:00
Joined
Jun 9, 2009
Messages
4,197
I have checked everything I can think of. Can’t figure out why report [rpt3Months] will not accept conditional formatting on field/control {sugar} but in the same DB accepts conditional formatting on report [rptAll]
 

Attachments

  • DicksVitalsAllYearsfindcondformat.zip
    326.4 KB · Views: 115

Gasman

Enthusiastic Amateur
Local time
Today, 16:00
Joined
Sep 21, 2011
Messages
14,044
A quick look does not show anything standing out.?

However I would probably have one report and open with different criteria.?

So use rpt all and filter?
Else copy report all and amend for source.?
 

Gasman

Enthusiastic Amateur
Local time
Today, 16:00
Joined
Sep 21, 2011
Messages
14,044
Thought I'd found it as the forecolor in rptall is different from rpt3months, but even after copying the forecolor it does not vchange? :confused:
 

June7

AWF VIP
Local time
Today, 08:00
Joined
Mar 9, 2014
Messages
5,423
Field Sugar is a text type, not number. For some reason Access is casting the text to number for rptAll but fails for rpt3Months. Copying rptAll and changing RecordSource does work. So, possibly rpt3Months is corrupted.

I agree, 1 report object should serve both outputs. Not showing Weight field on rptAll.
Docmd.OpenReport "rptAll", acViewPreview, , "EnterDate Between #8/21/2019# And #11/30/2019#"

Dynamically build filter criteria with VBA. User would enter date range into unbound controls on form. Review http://allenbrowne.com/ser-62.html

Might want to rename tlbMain to tblMain.
 

Dick7Access

Dick S
Local time
Today, 12:00
Joined
Jun 9, 2009
Messages
4,197
A quick look does not show anything standing out.?

However I would probably have one report and open with different criteria.?

So use rpt all and filter?
Else copy report all and amend for source.?

I thought of that, but this is mostly for training. I was expecting someone to find some dumb thing I had done.
 

Users who are viewing this thread

Top Bottom