When setting the format property for a textbox containing a number the first parameter relates to a positive number, the second negative and the third to zero.
eg #,###; (#,###); 0
Is there a way of also formatting Null values in the same way without writing custom code?
Could you do an isnull in your query so that you don't get NULL showing on your report?
Jarret
|||I could. Just means I have to either type this in for every column in my dataset or every textbox (instead of doing a multi-select). Sounds a bit lazy I know but I have a lot of reports and columns to go through.
Mark
|||Sorry Mark, I can't seem to find anything that will replace NULL with a 0 just by changing using the format code.
I think you're best bet is using the ISNULL or an expression, but either way, you'd have to change each field.
Jarret
No comments:
Post a Comment