Passing NULL values to MySQL Stored Procedure

[dabruins]

I have created a MySQL stored procedure to insert new records into a table that has a number of fields that accept NULL values. On my Frontend Access database I have a form for inputting the values for the new record. I am encountering problems passing NULL values to the MySQL SP. The NULL's get converted to empty strings for text columns and to empty fields for numeric columns.

I am using an ADO command object to pass the call to the SP using its CommandText property. The actual text passed contains a series of variables initialized and set inside the VBA environment. These act as IN parameters within the SP.

Does anyone have a workable technique they could share for passing NULL values from VBA to MySQL Stored Procedures?

Thanks.