J
john431
The fourth statement in this code returns an error message when the
expression has no value. The error code is 2427 -"You entered an expression
that has no value." When MyValue has a value, in this case a date, then
there is no error. This is part of a function module that I am using to
test the expression for either a value or no value at all.
1. DoCmd.OpenReport "Patient Refill QueryRpt", acViewPreview
2. DoCmd.Maximize
3. DoCmd.RunCommand acCmdZoom100
4. MyValue = Reports![Patient Refill QueryRpt].[ReOrder Date]
5. If IsEmpty (MyValue) = True Then
I have tried many variations of this statement but have not been able to
eliminate the error. Any ideas would be very much appreciated.
John
expression has no value. The error code is 2427 -"You entered an expression
that has no value." When MyValue has a value, in this case a date, then
there is no error. This is part of a function module that I am using to
test the expression for either a value or no value at all.
1. DoCmd.OpenReport "Patient Refill QueryRpt", acViewPreview
2. DoCmd.Maximize
3. DoCmd.RunCommand acCmdZoom100
4. MyValue = Reports![Patient Refill QueryRpt].[ReOrder Date]
5. If IsEmpty (MyValue) = True Then
I have tried many variations of this statement but have not been able to
eliminate the error. Any ideas would be very much appreciated.
John