cbo box not showing format ASP-8000-1RE but ASP80001RE

[Chris]

I have a table called Products with a two fiels ProductID (AutoNumber,
primary key) and ProductNo (Text) the input mask for the ProductNo is

LLL\-AAAA\-aaa and works on inputing data directly into the table and on

form called AtlasProducts.

However I have a Quotes form where I want to have a combo box with a drop
down list showing the list of ProductNo's from the table Products the
problem is the data shows without the - hyphens but just as ASP80001RE

When I look at the data in the table everything looks ok. I would prefer the
user to see it with hypens as this is how they are used to viewing Product
No's Any ideas why this is not working and how to correct it.

Thanks
Chris

 

[John Spencer (MVP)]

Put the ProductID and ProductNo field in the combobox's row source and hide the
ProductID and show the second a formatted ProductNo.

THE query would look something like:

SELECT ProductID, Format(ProductNo,"@@@-@@@@-@@@") as ShowProd
FROM Products
ORDER BY ProductNo