While using append Q I lose formatting information in destination table

[cktopher]

While using append Q I lose formatting information in destination table.
How on earth do I transfer the formatted information with out losing it when using append Q?
I am new to access so VBA code is not an option for me.

Picture tells a thousand words, See image below.

[June7]

Formatting doesn't transfer. Format property does not alter the original data, it is only a display setting. If you want the PartNumber field in PartsT to be formatted then set up formatting in that table. This is why I advise against setting these properties in table. They obscure the actual data and cause confusion.

PartNumber field in NewCCMPartsT is an autonumber field. It can't have text characters.

If you really want the alpha parts committed in the destination field, use Format() function on the field in the Append action. This will change the value that is saved.

[cktopher]

Thanks June7,
But how where and how do I use Format()?

[June7]

In the query.

"CMM-" & Format([ID],"000")