https://community.hpe.com/t5/backoffice-products/ms-access-formatting-all-fields/m-p/4745405#M2820 I think your best bet will be <A href="http://support.microsoft.com/" target="_blank">http://support.microsoft.com/</A><BR /><BR />Roger Sat, 29 Jan 2011 05:00:37 GMT Roger Faucher 2011-01-29T05:00:37Z https://community.hpe.com/t5/backoffice-products/ms-access-formatting-all-fields/m-p/4745404#M2819 Hi there<BR /><BR />Not sure if this is the right forum but could not find anything specfic to MS Office.<BR /><BR />I know how to format a single field in MS access:<BR /><BR />select Format([PVP],'General Number') as PVP_ from ns_data where PVP Is Not Null;<BR /><BR />How do I format all the fields, without listing them all ? (there is around 120 of them)<BR /><BR />I've tried this:<BR /><BR />select Format([*],'General Number') from ns_data;<BR /><BR />No luck.<BR /><BR />Regards<BR /><BR />Peter Fri, 28 Jan 2011 15:00:38 GMT https://community.hpe.com/t5/backoffice-products/ms-access-formatting-all-fields/m-p/4745404#M2819 Piotr Kirklewski 2011-01-28T15:00:38Z https://community.hpe.com/t5/backoffice-products/ms-access-formatting-all-fields/m-p/4745405#M2820 I think your best bet will be <A href="http://support.microsoft.com/" target="_blank">http://support.microsoft.com/</A><BR /><BR />Roger Sat, 29 Jan 2011 05:00:37 GMT https://community.hpe.com/t5/backoffice-products/ms-access-formatting-all-fields/m-p/4745405#M2820 Roger Faucher 2011-01-29T05:00:37Z