Windows 7 64bit 
Access 2010 32bit
I wanted to thank you for your interest this forum, it has moved me forward. I am afraid I have coded myself into a corner, tho. I would love to send you my db but I don't think the issue can be reproduced without it. It is filled with sensitive data.
I have a situation where during execution of report on format code, the values being checked are being ignored.
For example : if place the contents of the value of chkDiscrepSE in a text box on my report, it will contain a "No" (default value) but it actually executes as a yes. Right there on the printed or previewed page. It seems to arbitrarily do this. There is no record with data in it which would cause it to be set to yes for at least a half dozen records following, and this is the first printed result - first record.
Is there something about report on format code that is weird this way? The value of the chkDiscrepSE variable is set properly every time earlier in the code, but when it hits this spot (and others) it just ignores the value and executes anyway.
me.text140 = chkDiscrepSE
If chkDiscrepSE = "Yes" Then
me.text141= chkDiscrepSE
Me.discrepSELabel.Visible = True
Me.discrepSELine.Visible = True
UPDATE: This can happen randomly during execution. Places where the if's execute properly on one report fail in others.
UPDATE: If I print an individual record and not a group of them, it works fine. I was attempting to use a single print command with a filter. With the subreport attached it fails to accurately process the format event code. Currently I am intending to loop thru a list, issuing separate print commands. If anyone wants to comment on what they think might be wrong here, I'd be obliged.
Reply With Quote
