General :: Missing Zeros At Beginning Of Zip Code

I have a accdb pointed at Sql Server 2012 via ODBC pushing text from a text box back to a Sql server's column that is a nvarchar(10) to store zip codes.

Edit: I confirmed that the accdb's linked table has a datatype of text for the zip code column.

Oddly, the Access form's textbox is sending back the text, but stripping out the preceeding zero in the zip code - almost like when excel (shudder) strips the preceeding zeros away from SSNs and Zipcodes - treating them like a number - and not text.

How do I stop this?

The form object is a text box, and the sql server backend doesn't mind the preceeding zero. When I manually set the value to = '01111' using sql server management studio, the value is accepted - and then later viewable (with the zero) when using the accdb's form...

This leads me to believe the form is stripping away the zero when inserting the record. The add records button uses the following to insert the records:

Code:
Private Sub btnAddDioOffice_Click()
Dim strSQL As String
If ListBoxDios.Value <> "" And txtDioOffName.Value <> "" Then

[Code].....