Code for calculating nettweight and loss

[Niko]

Hi all, I have an issue with my form for my "nettweight" and "loss" textbox which keep showing #type! on my textbox after i click on "Clear" on my textbox. I realize that it is because i use these two textbox control source for calculation. Hence, once i removed the calculation in the control source, the #type! on my textbox was gone.

I would like to know how to write code so that when the form load together with all the data or when user click on 'next" for the next record set, it will automatically show the nettweight.
Formula: pounds/2.2

Next, i would like the code to work in the same way for the loss as well, when user key in the grossweight the loss will automatically be calculated and show in the loss textbox.



I have also attached my database above.

Thankyou! Have a good day

[June7]

Can't 'clear' a textbox with an expression. Can't set Value when there is an expression in the ControlSource.

It shows #Type! error because code is setting Pound and Grossweight textboxes to an empty string and can't do arithmetic with an empty string. Set the Pound and Grossweight controls to Null instead.

[Niko]

Can't 'clear' a textbox with an expression. Can't set Value when there is an expression in the ControlSource.

It shows #Type! error because code is setting Pound and Grossweight textboxes to an empty string and can't do arithmetic with an empty string. Set the Pound and Grossweight controls to Null instead.

Yup, i know. thats why i will need to find a way to include the calculation. Hence, i am thinking of using VBA code to do that? I tried before update but it does not seem to be working.
Do you have any idea?

[June7]

Remove the code that tries to set value of Netweight and Loss. Instead of setting Pound and Grossweight to empty string, set to Null.

[Niko]

Remove the code that tries to set value of Netweight and Loss. Instead of setting Pound and Grossweight to empty string, set to Null.

what is the reason behind by setting pound and grossweight to null?

[ssanfu]

@Niko,

Please stick with one thread......
earlier thread https://www.accessforums.net/showthread.php?t=68484

[June7]

Set to Null so the expression is not attempting arithmetic calculation with empty string resulting in the error. Arithmetic calculation with Null will return Null, no error.

[Micron]

Set to Null so the expression is not attempting arithmetic calculation with empty string resulting in the error. Arithmetic calculation with Null will return Null, no error.

Too bad I didn't see this before wasting so much time elsewhere.