Change Table Field Format via Code

[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?

 

[Tim Ferguson]

I wish to
change the format property for field_name to fixed with no
decimal places.

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

Forms!SomeForm!txtControlName.Format = "0"

Hope that helps


Tim F

 

[John Vinson]

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?

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.