updating field to null

[111]

I have a SETVALUE problem where:

item:[Forms]![Profit Tracking 2]![Sell Rate]
expression:[Forms]![Profit Tracking 2]![Profit
Tracking(Receivables)].[Form]![inv total]

This works fine aslong as there is always something in [inv total] - even 0.00
will work. but if [inv total] is null (ie the user deletes the record) the SELL
Rate field will not update to "Null" (or nothing). Is there something i can add
to the expression to allow for setvalue to be null? i can't have 0.00 in the
field as this will screw up another part of the program . if it's null it has
to show null.

any advise is greatly appreciated.

 

[Michael Cheng [MSFT]]

Hi,

From your descriptions, I understood that you would like to set the field
as zero when it is null in [inv total]. Have I understood you? If there is
anyting I misunderstood, please feel free to let me know

Based on my knowledge, You can use the Nz function to return zero, a
zero-length string (" "), or another specified value when a Variant is
Null. For example, you can use this function to convert a Null value to
another value and prevent it from propagating through an expression.

You could make your expression like this: Nz ([Forms]![Profit Tracking
2]![Profit Tracking(Receivables)].[Form]![inv total])

For more information about Nz Functions, you could get from Access Help or
MSDN Online
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac10/htm
l/acfctnz.asp

Hope this helps and if you have any questions or concerns, don't hesitate
to let me know. We are here to be of assistance!

Sincerely yours,

Michael Cheng
Microsoft Online Support
***********************************************************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.

 

[Michael Cheng [MSFT]]

Hi,

I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!

Sincerely yours,

Michael Cheng
Microsoft Online Support
***********************************************************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.