My simple problem is that I have a form where sometimes the values have to be Null, and appear blank in Print View on the form. I simply wish to make these Null values APPEAR as something like '****' on the printed version of the form, meanwhile keeping the Null value the same on the table. How do I go about accomplishing this? My thanks in advance for your time!!
the easiest way is to stick on the report functions instead of values. You can have one function and call it or you can have on each field separate function. Better would be to have one function, cauze if you change your mind and don't like * anymore, you can replace it easily with -
put this function to modules
Public Function MyNullValue(InputValue As Variant) As Variant
If IsNull(InputValue) Then
MyNullValue = "*****"
MyNullValue = InputValue
then you can use it on your report, instead of each field, put to CONTROL SOURCE
don't forget that the NAME of the TEXT BOX has to be different than the name of the table field!
so if your field is MYFIELD, textbox name can be let's say MyFieldNull but not MyField
The other thing I neglected to mention is that some values are reliant on what the other values are, thus If I fully replace a Null Value with stars then it hoses up other reliant values. That is why I am looking for a masking technique of some type, so that the printed report shows '****' for a placeholder instead of the raw blank area, however the value on the query is still Null.