Export have missing data

[drunkenneo]

I have a primary Key in table with input mask as M00000, but when exported it comes without M only digits are coming any suggestions on this?

[JoeM]

What exactly is being entered into these fields? I am guessing that maybe you are just entering numbers, and the mask is displaying the "M".
Is this field's data type Text or Numeric?

How exactly are you exporting the data?
Which method are you using and what kind of file are you exporting to (text, Excel, etc)?

[drunkenneo]

What u guessed about maskin is correct its an autonumber, i am exporting by makon select query only and using export excel in this

[JoeM]

How do you do that?
If I select the "Autonumber" Data Type, it does not even give me a Input Mask property option (because with Autonumber, you are not actually entering anything, it is populated automatically).
I see a "Format" option. Is this what you are using?

[drunkenneo]

Yes thats right

[JoeM]

When I tried to enter M00000 in the Format field in my Access, it does weird things, and changes it to m"00000".
It might be best if you do into the Properties of this field, so a screen print, and post it here, so we can see exactly how all the Properties of this field are set.

[drunkenneo]

Make it to \M00000, it will gie the requored result as it negate M and take it as constant

[JoeM]

i am exporting by makon select query only and using export excel in this

On the Export screen, underneath the "File name" and "File format" parameters, there should be a check box that says "Export data with formatting and layout".
If you check this box, then the data will be exported with the custom format with the "M" you set up.

[drunkenneo]

can this be done through the transfersheet code

[JoeM]

When it comes to maintaining formatting, I have had better luck using the OutputTo option than TransferSpreadsheet.