Can anyone help with this? It will sound weird to you and you probably will think I'm pulling your leg but it is all true!
I look after an Access 2000 Database. There is an existing report to which I added two new columns - one shows the results of a text box (where the values are H or S or blank) and the other shows the results of a tick box. in the report, the latter says "If True, then display A else blank"
On my screen, when I run the report, I get the values as expected - H or S in the first column, and A in the second as appropriate.
However, my users rang to say they weren't seeing the values - firstly some of (the four of) them were OK and others weren't...then none of them were seeing the values.
I went up to see them and, sure enough, they can't see the values. I checked the underlying query...it is pulling the values in but the report won't show them. The other fields for the detail line display fine but not these two.
To be precise, it would show S in the first column but not H.
I changed the H values in the underlying table to be X - and they displayed OK! A, B etc were no good but X was fine.
Similarly, for the text box column, A or D or P or W wouldn't display if the condition was True but Y does display.
So, what on earth is going on?
Andrew
I look after an Access 2000 Database. There is an existing report to which I added two new columns - one shows the results of a text box (where the values are H or S or blank) and the other shows the results of a tick box. in the report, the latter says "If True, then display A else blank"
On my screen, when I run the report, I get the values as expected - H or S in the first column, and A in the second as appropriate.
However, my users rang to say they weren't seeing the values - firstly some of (the four of) them were OK and others weren't...then none of them were seeing the values.
I went up to see them and, sure enough, they can't see the values. I checked the underlying query...it is pulling the values in but the report won't show them. The other fields for the detail line display fine but not these two.
To be precise, it would show S in the first column but not H.
I changed the H values in the underlying table to be X - and they displayed OK! A, B etc were no good but X was fine.
Similarly, for the text box column, A or D or P or W wouldn't display if the condition was True but Y does display.
So, what on earth is going on?
Andrew