Hi
I searched the web for some time now and can't find a solution, maybe someone here might be able to help.
I have a Listbox in my form and want to format the entries like 00-0000-00.
If the entries only contain numbers, this is working like a charm by using this as Row Source
SELECT [tblBase].[ID], Format([tblBase].[Ate],"00-0000-00") FROM tblBase ORDER BY [Ate];
The problem is that these entries might also contain letters. I already tried the placeholders I could think of but can't get it to work properly.
Someone's got an idea?