Dear reader(s),
I have a problem with a report: I would like to strikethrough (with a line) a value on a report. I have already tried to use an if-statement with the Visible-property and temporary values of the DLookup values to get the line on the screen.
The problem is that the DLookup values are empty when setting them and I cannot set the value of the two listboxes (Old number and New number), which is very strange in my opinion.
The values of Old number and New number are filled by DLookup, so the strikethrough has to be done after the setting of these variables.
Note 1: I have used the same strikethrough procedure as described above on the same report, but on a label instead of a listbox.
Note 2: The database crashed recently, could this also be a reason why this does not work?
Product Old New Description:
number number number
------- ----- ----- -----------------------------
- 123 - - 1 - - 2 - replace / add / remove
------- ----- ----- -----------------------------
Procedure of the program:
- a query is being executed to get the values of Old number and New number
- an if-statement is being runned after the values set in the listboxes
- the strikethrough is being performed
Thanks in advance!
Jochen. --------------------------------------------------------------------------------
It never hurts to help and it never helps to hurt.
I have a problem with a report: I would like to strikethrough (with a line) a value on a report. I have already tried to use an if-statement with the Visible-property and temporary values of the DLookup values to get the line on the screen.
The problem is that the DLookup values are empty when setting them and I cannot set the value of the two listboxes (Old number and New number), which is very strange in my opinion.
The values of Old number and New number are filled by DLookup, so the strikethrough has to be done after the setting of these variables.
Note 1: I have used the same strikethrough procedure as described above on the same report, but on a label instead of a listbox.
Note 2: The database crashed recently, could this also be a reason why this does not work?
Product Old New Description:
number number number
------- ----- ----- -----------------------------
- 123 - - 1 - - 2 - replace /
------- ----- ----- -----------------------------
Procedure of the program:
- a query is being executed to get the values of Old number and New number
- an if-statement is being runned after the values set in the listboxes
- the strikethrough is being performed
Thanks in advance!
Jochen. --------------------------------------------------------------------------------
It never hurts to help and it never helps to hurt.
