Initialize field with a blank

[GregFarrell]

I am in the process of modifiying the MS Access sample database "Northwind" or use at a local not for profit orginzation. I have very limited MS Access skills.

The subset of code below is from the Form "Order Subform for order details". In the field "Quanity" below, I would like the code to write a blank field rather than a "0".

In other words, the line
Me![Quantity]=0, should be something like Me![Quantity]=blank

I have tried using "" , "empty" and a few others. I have also tried using default values of such as "". Any help will be appreciated.


Private Sub Product_ID_AfterUpdate()
'Initialize price and discount for each product change
If Not IsNull(Me![Product ID]) Then
Me![Quantity] = 0


Me.Quantity.Locked = False
Me![Unit Price] = GetWholesalePrice(Me![Product ID])
Me![Discount] = 0
Me![Status ID] = None_OrderItemStatus

'Empty Product records mean user wants to delete line item
Else
eh.TryToRunCommand acCmdDeleteRecord
End If
End Sub

[pbaldy]

Try

Me![Quantity] = Null

[GregFarrell]

Thanks for the quick reply.
I tried entering Null. I get an error message "You tried to assign the Null value that is not a variant data type.

[pbaldy]

I suspect at the table level the Quantity field is set to not allow Nulls (Required = Yes), which is not necessarily a bad thing. You can try changing that, or live with the 0.

[GregFarrell]

Solved! I neglected to check the table properties. The Quanity field had a default value of 0 in the table. I was also able to change it to Required = No. Thanks for the help!!!

[pbaldy]

Happy to help. Personally I would likely leave the required property as Yes, to prevent records with no quantity, but you can see how it works as is.