Formatting different in form compared to table

[Accessbeginner34]

Hi,

I have a linked table in Excel which is the source for my data. When I review the contents in the Access Table - it all seems fine and the formatting of dates, currency, numbers with commas etc all matches the Excel spreadsheet. However, when I change into Form View, some of the items are wrong, for example the dates as shown just as the numbers with no formatting, £ signs are missing in currency and commas are missing from numbers.

When I look at this is design view in the table it appears as though the correct data type is selected, e.g date, currency etc.

Just wondered if anyone could help advise why the formatting isn't showing properly on the form?

Thanks

 

[Ranman256]

formatting is independent.
just like a query sort wont work in a report unless you set it in the report.

 

[Accessbeginner34]

Ah I see - so how do I change the format of the specific fields in the form so they show the date rather than just the number?

 

[MajP]

In design view, select your control and then edit the Format property.

 

[Accessbeginner34]

Thanks - that’s sorted most of the issues out. Some of the control boxes have an @ in the format and the drop down doesn’t give me any options to change. Any ideas on what’s causing this?

 

[Frothingslosh]

The @ is a character placeholder. It shows the appropriate character if that position in the string is filled, and a space otherwise. Note that it 'fills' placeholders from right to left, so spaces will be added to the start, not the end.

Basically, if the format is '@@@@@' and the data is 'ABC', the result is ' ABC'.

https://support.office.com/en-ie/article/format-a-text-field-a5e5bcde-85da-4c7a-8164-1fe286636668

 

[MajP]

If the field is a date you get some date choices, if a number or currency field you get number and currency choices. If it is text there are no default choices, but you can make custom formats
https://support.office.com/en-ie/ar...ta-types-0fe78ed3-f813-44d1-8374-568e72a72841

See the differences of using @ or &, but for most part the @ is doing nothing.

 

[Accessbeginner34]

Great - thanks all for your help