No date value missing sometimes on some rows not others (1 Viewer)

Curtis Hauser

New member
Local time
Today, 07:02
Joined
Nov 10, 2021
Messages
9
Some report rows are missing date value - may or may not be due to being a date - it's a text box on the report. And I verified there is a value in the corresponding field PLUS I filter the report by the date so that helps confirm there's a value there. It's just not displaying in some rows - see attached example.
 

Attachments

  • Access Report Missing Date Values.PNG
    Access Report Missing Date Values.PNG
    36.6 KB · Views: 250

theDBguy

I’m here to help
Staff member
Local time
Today, 05:02
Joined
Oct 29, 2018
Messages
21,358
Are you using any conditional formatting in that column? Are the missing dates all the same?
 

Curtis Hauser

New member
Local time
Today, 07:02
Joined
Nov 10, 2021
Messages
9
I found a solution on a related post ... had the HideDuplicates property set to Yes. Changing to No solved it.
 

Curtis Hauser

New member
Local time
Today, 07:02
Joined
Nov 10, 2021
Messages
9
But the dates were all 11/04/2021 ?
Correct - which really threw me initially. I noticed the 2 rows missing date values were the only 2 rows that had repeating values in their respective 1st column titled Area (Bulk 81-82 and Modula) - so maybe somehow that triggered the application of HideDuplicates property? Not really certain
 

Users who are viewing this thread

Top Bottom