473,325 Members | 2,442 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

formatting text nothing seems to fix errors LOL

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
4 1790
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: joe ruggeri | last post by:
Hey All ... I'm developing in ASP/VBScript using DreamweaberMX, w/ an Access 2000 DB as the data source. The source of the data is coming from a third party, which I get as a CSV and import into...
3
by: Jouke Langhout | last post by:
Hello all! For quite some time now, I've got the following problem: Access won't close properly when a user closes the application. An ACCESS process stays active and that process can only be...
4
by: Bradley | last post by:
I have an A2000 database in which I have a continuous form with a tick box. There is also a text box with a conditional format that is based on the expression , if it's true then change the...
4
by: cefrancke | last post by:
How does Stephen Lebans make the datasheet row color change by clicking a row's check box field? I cant find any code associated with the form, and I cant tell if you have created a class on the...
14
by: Scott M. | last post by:
Ok, this is driving me nuts... I am using VS.NET 2003 and trying to take an item out of a row in a loosely-typed dataset and place it in a label as a currency. As it is now, I am getting my...
1
by: Wayne Deleersnyder | last post by:
Hi All, I was going to write and ask if someone could help me fix the formatting of my output for hash values, but I believe I got it right now. But, because I couldn't find any website or...
0
mkozma
by: mkozma | last post by:
Hi, I know there are many articles on this topic but none seem to solve my problem. I have migrated a database (in US format) from SQL server 2005 to DB2 v9. The DB2 needs to work woth Australian...
5
by: Bret | last post by:
Does anyone know of a package that can be used to "fix" bad formatting in Python code? I don't mean actual errors, just instances where someone did things that violate the style guide and render...
3
by: =?Utf-8?B?b24tbGluZSBqb3VybmFsIGVkaXRvcg==?= | last post by:
I can't seem to cut-and-paste text, with either .doc or .html formatting, into my .asp web-pages --all the formatting is lost. Is there some code that needs to be added to the page that will...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.