Drop Down showing incorrect format

[mtagliaferri]

I have a datasheet form with a drop down list records are displayed with a dash after the first letter, suddenly for all new entries the dash does not show (Pic1). In the table they are displayed correctly.
Would I need to impose the format type as "L-LLLL" on the source in the source in the query (Pic2)

 

[arnelgp]

Use update query to add the dash:

Update tblfleet set dacregistration=left(dacregistration,1) & "-" & mid(dacregistration,2) where instr(dacregistration, "-")=0;

 

[mtagliaferri]

Confused:banghead:

Where Do I place

dacregistration=left(dacregistration,1) & "-" & mid(dacregistration,2) where instr(dacregistration, "-")=0;

And why old entries are showed correctly and suddently the new ones are not?

 

[isladogs]

Arnel is telling you to create an update query with that as the query sql.

However, if you are saying that the data is displayed correctly in the table, then whether that works will depend on whether the data is already stored like that in the table or if you've used field formatting to obtain that layout,

If the update query doesn't work, check the field formatting in both table and combo box

 

[mtagliaferri]

yes the format is correct in the table which has an input mask, I have other form displaying record from the table and are shown correctly, there is no format set on the drop down box.
How can it be that only the last few entries are incorrectly displayed?

 

[isladogs]

Impossible to say why from the info you have provided.
Have you run the update query?
Have you tried adding a suitable format to the combo?

 

[June7]

The input mask is not set to save the punctuation. Suspect the mask has been changed. Old entries have been saved with the hyphen and new entries have not.

If the mask is set in the table, data will show with hyphen. However, combobox list shows the actual data.

Is there ever another prefix than G-?

 

[mtagliaferri]

No other prefix .....

 

[June7]

Then why save the G- prefix into data? It can be concatenated in an expression. Or if you really want to save it, make it a mask character so user does not even have to type it and set mask to save the mask characters. https://support.office.com/en-us/ar...ut-masks-E125997A-7791-49E5-8672-4A47832DE8DA