By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,294 Members | 2,681 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,294 IT Pros & Developers. It's quick & easy.

formatting text nothing seems to fix errors LOL

P: n/a
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?

Feb 23 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Feb 23, 9:10 am, sparks <jstal...@swbell.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.
Feb 23 '07 #2

P: n/a
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.
Feb 23 '07 #3

P: n/a
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.comwrote:
>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.
Feb 23 '07 #4

P: n/a
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.comwrote:

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

Feb 24 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.