Help Needed to Format Field in Access Table

[howardr]

Hello,

I am probably missing something very obvious, but I am trying to Format a field in my Access table so that it is Standard and has 6 Decimal Places.

Eventually, I will need to know how to format another field in the table to Text (I thought I would ask now, while I was here)

Thank you so much for your help!

 

[13badar]

GOTO Design View of the Table
On the Top Half of your screen, U'll see a list of Your Table Fields alongwith their respective DataTypes on the RHS.
After Selecting Number, On the bottom half of the screen, there are GENERAL properties. Just pick Decimal Places '2' instead of AUTO. Do the same for TEXT.

 

[howardr]

Thanks 13badar,

I guess I didn't state that I wanted to make this format / decimal place change within the VBA code I am writing.

Any suggestion on that?

Thanks!