Change Table Field Format via Code

  • Thread starter Thread starter Chris Eberhart
  • Start date Start date
C

Chris Eberhart

I need to change the formatting on a table field using
code. I know the table_name and field_name. I wish to
change the format property for field_name to fixed with no
decimal places.

Thank you in advance for your help.

P.S. Where is a good source for this type of information?
 
I wish to
change the format property for field_name to fixed with no
decimal places.
Click to expand...

These are display properties, so you can change them on the form:

Forms!SomeForm!txtControlName.Format = "0"

Hope that helps


Tim F
 
I need to change the formatting on a table field using
code. I know the table_name and field_name. I wish to
change the format property for field_name to fixed with no
decimal places.

Thank you in advance for your help.

P.S. Where is a good source for this type of information?
Click to expand...

Ummm... why do you need to do this? Users should generally never see a
table datasheet, and you can set the Format property of a Form or
Report control as needed; the format of the table field is (I admit)
the default, but it's easily overridden.
 
Back
Top