formatting text nothing seems to fix errors LOL

[sparks]

In this database some of the text boxes need to be/show something like
88.9.

in the table I marked them single, format 00.0 and decimal places 1
on the form I have fixed and 1
if someone types in 88.9 its fine....if they type in 88.99 it gets
displayed as 89.0 but in the table its 88.99 when you click on the
value in the table.

I wanted to do something like ##.# so they had to put in the correct
thing but they might have 5.6 and having to put in a leading 0 was not
an option.

so they are not putting in .99 (this would be a data entry error) and
I assume ignore the last 9

but I need to display and store only single decimal places with no
rounding.
how can I fix this?

[Gord]

On Feb 23, 9:10 am, sparks <jstal...@swbel l.netwrote:

In this database some of the text boxes need to be/show something like
88.9.

in the table I marked them single, format 00.0 and decimal places 1
on the form I have fixed and 1
if someone types in 88.9 its fine....if they type in 88.99 it gets
displayed as 89.0 but in the table its 88.99 when you click on the
value in the table.

I wanted to do something like ##.# so they had to put in the correct
thing but they might have 5.6 and having to put in a leading 0 was not
an option.

so they are not putting in .99 (this would be a data entry error) and
I assume ignore the last 9

but I need to display and store only single decimal places with no
rounding.

how can I fix this?

Try using the data type "Currency" instead of "Single". Set the Format
to "Standard" and the Decimal Places to 1.

[salad]

sparks wrote:

In this database some of the text boxes need to be/show something like
88.9.

in the table I marked them single, format 00.0 and decimal places 1
on the form I have fixed and 1
if someone types in 88.9 its fine....if they type in 88.99 it gets
displayed as 89.0 but in the table its 88.99 when you click on the
value in the table.

I wanted to do something like ##.# so they had to put in the correct
thing but they might have 5.6 and having to put in a leading 0 was not
an option.

so they are not putting in .99 (this would be a data entry error) and
I assume ignore the last 9

but I need to display and store only single decimal places with no
rounding.
how can I fix this?

You might want to consider using an input mask.

[sparks]

Salad I tried 999.9

this works fine....if I put in 33.33 it just cuts if off and makes it
33.3.
the problem I was having with the data entry people was
when you tabbed into the field you see ___._
and they thought that with this 3.1 if you were putting in 5.5 you had
to put in 005.5

I said try it, just type in 5.5....it works but it looks funny.
I said why are you looking at the screen.

I think I convinced them :)
On Fri, 23 Feb 2007 16:40:46 GMT, salad <oi*@vinegar.co mwrote:

>sparks wrote:

>In this database some of the text boxes need to be/show something like
88.9.

in the table I marked them single, format 00.0 and decimal places 1
on the form I have fixed and 1
if someone types in 88.9 its fine....if they type in 88.99 it gets
displayed as 89.0 but in the table its 88.99 when you click on the
value in the table.

I wanted to do something like ##.# so they had to put in the correct
thing but they might have 5.6 and having to put in a leading 0 was not
an option.

so they are not putting in .99 (this would be a data entry error) and
I assume ignore the last 9

but I need to display and store only single decimal places with no
rounding.
how can I fix this?

You might want to consider using an input mask.

[salad]

sparks wrote:

Salad I tried 999.9

this works fine....if I put in 33.33 it just cuts if off and makes it
33.3.
the problem I was having with the data entry people was
when you tabbed into the field you see ___._
and they thought that with this 3.1 if you were putting in 5.5 you had
to put in 005.5

I said try it, just type in 5.5....it works but it looks funny.
I said why are you looking at the screen.

I think I convinced them :)

The problem you have is the placeholder. In the property sheet go to
the InputMask property and click the triple dots. Edit the list and
create a new input mask record. Accept the default placeholder.

Save the input mask. Now, click Next. It will prompt you for the
placeholder. Select " ". Then hit finish. Here's a sample of mine
9999-99;;" "

You won't get the _, just spaces.

>

On Fri, 23 Feb 2007 16:40:46 GMT, salad <oi*@vinegar.co mwrote:

>>sparks wrote:

>>>In this database some of the text boxes need to be/show something like
88.9.

in the table I marked them single, format 00.0 and decimal places 1
on the form I have fixed and 1
if someone types in 88.9 its fine....if they type in 88.99 it gets
displayed as 89.0 but in the table its 88.99 when you click on the
value in the table.

I wanted to do something like ##.# so they had to put in the correct
thing but they might have 5.6 and having to put in a leading 0 was not
an option.

so they are not putting in .99 (this would be a data entry error) and
I assume ignore the last 9

but I need to display and store only single decimal places with no
rounding.
how can I fix this?

You might want to consider using an input mask.