Number format Access/Sharepoint

[JamesN]

Hi,

I am in the process of publishing a split access database to sharepoint (access2010/sharepoint 2013)

The database includes a form and table which are linked for data entry purposes. One of the fields are CaseID formatted as a general number without decimal places to remove any commas etc. When i publish to sharepoint it is changing this format and commas are showing?

Is there a fix for this?

Thanks

 

[GohDiamond]

Try changing in the table from General number to Fixed and Decimal places 0

Cheers!
Goh

 

[JamesN]

Thanks for your reply. I tried this but when publishing on sharepoint it kept stripping this change out and reverting the file to default. I managed to store it as a text field and got it working.

Cheers