There was a property called FORMAT in the textbox control for Access. I threw in the proper formatting and the problem went away.