Custom datat types with ACCESS and VB6

[kellyputty]

Hiya,

When I make a custom data type in ACCESS for the input mask of a field in design view of a table, the data does display the correct format.
However, when I create a VB interface to query the data it only finds the data without the correct mask.

For example:

Custom Data Type: ###-#### can only be found by a query if I leave out the hyphen #######. I need the hyphen to stay in there. I don't know what is going on because in the database the data is in the custom format.
Any Thoughts,
KellyPutty

 

[kellyputty]

Skip this last question, I took out all formatting in Access. It doesn't belong there anyways.

Kelly