A Access New member Local time Today, 11:01 Joined Mar 2, 2009 Messages 1 Mar 2, 2009 #1 Hi I need some code that when running a macro it will show the field as 100.00 and not as 100. I have tried the decimal points but this has not worked. Anyone please?
Hi I need some code that when running a macro it will show the field as 100.00 and not as 100. I have tried the decimal points but this has not worked. Anyone please?
Dennisk AWF VIP Local time Today, 11:01 Joined Jul 22, 2004 Messages 1,649 Mar 2, 2009 #2 I assume you mean query. Select the column, right click and enter the number format of your choice.