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?

"Chris Eberhart" <(E-Mail Removed)> wrote in
news:197e401c44cd4$1c86a3a0$(E-Mail Removed):

> 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

On Mon, 7 Jun 2004 14:12:16 -0700, "Chris Eberhart"
<(E-Mail Removed)> wrote:

>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.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public