Formatting different in form compared to table (1 Viewer)

Accessbeginner34 · Mar 18, 2019

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 · Mar 18, 2019

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

Accessbeginner34 · Mar 18, 2019

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 · Mar 18, 2019

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

Accessbeginner34 · Mar 18, 2019

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 · Mar 18, 2019

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 · Mar 18, 2019

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 · Mar 18, 2019

Great - thanks all for your help

Formatting different in form compared to table (1 Viewer)

Accessbeginner34

Registered User.

Ranman256

Well-known member

Accessbeginner34

Registered User.

MajP

You've got your good things, and you've got mine.

Accessbeginner34

Registered User.

Frothingslosh

Premier Pale Stale Ale

MajP

You've got your good things, and you've got mine.

Accessbeginner34

Registered User.

Similar threads

Users who are viewing this thread