Show 2 Decimal Places in Table

[waq963]

Hi, Basically i have a form withtextboxes that show numbers with 2 decimal places, they have been set to General NUmber and Decimal Places:2. But when i add them to the tables using the Add Recordset function they appear as Whole Numbers? I've tried various formatting styles for the fields in Table Design View but i either get too many digits or whole numbers??? Thanks

 

[Brianwarnock]

Why not used fixed and 2 decimal places in both places?

brian

 

[statsman]

First, have you set the format in the actual table to allow decimals? If so you may approach this in two ways:

On your form set the textbox to standard number, then set the decimal to 2 OR

In the textbox's format property, set it to 0.00 (zero point zero zero)

 

[missinglinq]

If your numbers are being stored in the table as whole numbers, you've defined the field, in your table defs, as an Integer. Open your table in Design View and select the field and change the Field Size from Integer to Single.

 

[waq963]

Thanks for the reply guys, I used the Fixed Decimal in both places concept. Another quick question, Is it possible to set a textbox to show a figure with decimal places and figures that aren't? Because sometimes i get values that are whole numbers and don't want the decimal there? Thanks

 

[Brianwarnock]

That's reverse of what people normally want. I would try a format of #.##


Brian