display exact number

[alex]

Hello,

using Access '03...

I have a form with two textboxes. One for entering a number and one
for displaying a number.

I'm trying to format them to display the exact number as it's
entered. I've tried adjusting the format, but it's not working.

For example:
I enter 9.5 and the textbox displays 9.50. I could use #.0 in the
format box, but then if I enter 5.75, it will truncate or round.

Also, I'd like .5 to be displayed as .5 and not 0.5.

For some reason my table will display/hold 9.5 as 9.5, it's just my
form. The table datatype is single.

thanks,
alex

 

[Wayne-I-M]

It should work ??

Try adding an unbound text box to your form - "don't" set any format for this

Use the sourse
=[YourNumberField]

and see what happens

 

[Wayne-I-M]

ooops - I should have said not to set the format for the new box but the
bound box should be General Number


--
Wayne
Trentino, Italia.

It should work ??

Try adding an unbound text box to your form - "don't" set any format for this

Use the sourse
=[YourNumberField]

and see what happens

--
Wayne
Trentino, Italia.

Hello,

using Access '03...

I have a form with two textboxes. One for entering a number and one
for displaying a number.

I'm trying to format them to display the exact number as it's
entered. I've tried adjusting the format, but it's not working.

For example:
I enter 9.5 and the textbox displays 9.50. I could use #.0 in the
format box, but then if I enter 5.75, it will truncate or round.

Also, I'd like .5 to be displayed as .5 and not 0.5.

For some reason my table will display/hold 9.5 as 9.5, it's just my
form. The table datatype is single.

thanks,
alex

 

[alex]

ooops - I should have said not to set the format for the new box but the
bound box should be General Number

--
Wayne
Trentino, Italia.

It should work ??

Try adding an unbound text box to your form - "don't" set any format for this

Use the sourse
=[YourNumberField]

and see what happens

"alex" wrote:

- Show quoted text -

Thanks Wayne for replying.

I changed one of my textboxes to General Number, as you suggested
above.
You're right, the textbox will display (for example) 2.5 and not
2.50. The problem, however, is that it will round 3.25 to 3.3. I
need it to keep 3.25.

Am I just missing another formatting option?
alex

 

[alex]

ooops - I should have said not to set the format for the new box but the
bound box should be General Number

It should work ??
Try adding an unbound text box to your form - "don't" set any format for this
Use the sourse
=[YourNumberField]
and see what happens
--
Wayne
Trentino, Italia.
:
Hello,
using Access '03...
I have a form with two textboxes.  One for entering a number and one
for displaying a number.
I'm trying to format them to display the exact number as it's
entered.  I've tried adjusting the format, but it's not working.
For example:
I enter 9.5 and the textbox displays 9.50.  I could use #.0 in the
format box, but then if I enter 5.75, it will truncate or round.
Also, I'd like .5 to be displayed as .5 and not 0.5.
For some reason my table will display/hold 9.5 as 9.5, it's just my
form.  The table datatype is single.
thanks,
alex- Hide quoted text -

- Show quoted text -

Thanks Wayne for replying.

I changed one of my textboxes to General Number, as you suggested
above.
You're right, the textbox will display (for example) 2.5 and not
2.50.  The problem, however, is that it will round 3.25 to 3.3.  I
need it to keep 3.25.

Am I just missing another formatting option?
alex- Hide quoted text -

- Show quoted text -

Wayne,

Not sure if this helps...
My textbox is bound to a query that uses a Sum function. I think I
may have to format that function to avoid the rounding.
alex

 

[alex]

On Jan 16, 9:09 am, Wayne-I-M <[email protected]>
wrote:

ooops - I should have said not to set the format for the new box but the
bound box should be General Number
--
Wayne
Trentino, Italia.
:
It should work ??
Try adding an unbound text box to your form - "don't" set any format for this
Use the sourse
=[YourNumberField]
and see what happens
--
Wayne
Trentino, Italia.
:
Hello,
using Access '03...
I have a form with two textboxes.  One for entering a number and one
for displaying a number.
I'm trying to format them to display the exact number as it's
entered.  I've tried adjusting the format, but it's not working..
For example:
I enter 9.5 and the textbox displays 9.50.  I could use #.0 in the
format box, but then if I enter 5.75, it will truncate or round.
Also, I'd like .5 to be displayed as .5 and not 0.5.
For some reason my table will display/hold 9.5 as 9.5, it's just my
form.  The table datatype is single.
thanks,
alex- Hide quoted text -
- Show quoted text -

Thanks Wayne for replying.

I changed one of my textboxes to General Number, as you suggested
above.
You're right, the textbox will display (for example) 2.5 and not
2.50.  The problem, however, is that it will round 3.25 to 3.3.  I
need it to keep 3.25.

Am I just missing another formatting option?
alex- Hide quoted text -

- Show quoted text -

Wayne,

Not sure if this helps...
My textbox is bound to a query that uses a Sum function.  I think I
may have to format that function to avoid the rounding.
alex- Hide quoted text -

- Show quoted text -

....It's not the query; the query is diplaying the number (for example)
as 3.75. It's just the textbox that rounds the number!

 

[John Spencer (MVP)]

IF you want the number displayed exactly as you enter it, then you will
probably have to use a text field and use conversion functions [such as the
Val() function] when you want to do math.

For instance entering the following variations of .5
0.5
0.500
.5
.500
000.5

will all be stored as .5 and will display according to the format you choose.

I guess you could use two fields in your table (a text field and a number
field). In a form, you could update the number field based on the value of
the text field, but that just begs for bad data to creep into your table.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[BruceM]

Be sure the text box decimal places are set properly.

On Jan 16, 9:09 am, Wayne-I-M <[email protected]>
wrote:

ooops - I should have said not to set the format for the new box but
the
bound box should be General Number
--
Wayne
Trentino, Italia.
:
It should work ??
Try adding an unbound text box to your form - "don't" set any format
for this
Use the sourse
=[YourNumberField]
and see what happens
--
Wayne
Trentino, Italia.
:
Hello,
using Access '03...
I have a form with two textboxes. One for entering a number and
one
for displaying a number.
I'm trying to format them to display the exact number as it's
entered. I've tried adjusting the format, but it's not working.
For example:
I enter 9.5 and the textbox displays 9.50. I could use #.0 in the
format box, but then if I enter 5.75, it will truncate or round.
Also, I'd like .5 to be displayed as .5 and not 0.5.
For some reason my table will display/hold 9.5 as 9.5, it's just
my
form. The table datatype is single.
thanks,
alex- Hide quoted text -
- Show quoted text -

Thanks Wayne for replying.

I changed one of my textboxes to General Number, as you suggested
above.
You're right, the textbox will display (for example) 2.5 and not
2.50. The problem, however, is that it will round 3.25 to 3.3. I
need it to keep 3.25.

Am I just missing another formatting option?
alex- Hide quoted text -

- Show quoted text -

Wayne,

Not sure if this helps...
My textbox is bound to a query that uses a Sum function. I think I
may have to format that function to avoid the rounding.
alex- Hide quoted text -

- Show quoted text -

....It's not the query; the query is diplaying the number (for example)
as 3.75. It's just the textbox that rounds the number!

 

[alex]

Be sure the text box decimal places are set properly.

On Jan 16, 9:09 am, Wayne-I-M <[email protected]>
wrote:
ooops - I should have said not to set the format for the new box but
the
bound box should be General Number
--
Wayne
Trentino, Italia.
:
It should work ??
Try adding an unbound text box to your form - "don't" set any format
for this
Use the sourse
=[YourNumberField]
and see what happens
--
Wayne
Trentino, Italia.
:
Hello,
using Access '03...
I have a form with two textboxes. One for entering a number and
one
for displaying a number.
I'm trying to format them to display the exact number as it's
entered. I've tried adjusting the format, but it's not working.
For example:
I enter 9.5 and the textbox displays 9.50. I could use #.0 in the
format box, but then if I enter 5.75, it will truncate or round..
Also, I'd like .5 to be displayed as .5 and not 0.5.
For some reason my table will display/hold 9.5 as 9.5, it's just
my
form. The table datatype is single.
thanks,
alex- Hide quoted text -
- Show quoted text -
Thanks Wayne for replying.
I changed one of my textboxes to General Number, as you suggested
above.
You're right, the textbox will display (for example) 2.5 and not
2.50. The problem, however, is that it will round 3.25 to 3.3. I
need it to keep 3.25.
Am I just missing another formatting option?
alex- Hide quoted text -
- Show quoted text -

Wayne,

Not sure if this helps...
My textbox is bound to a query that uses a Sum function. I think I
may have to format that function to avoid the rounding.
alex- Hide quoted text -

- Show quoted text -

...It's not the query; the query is diplaying the number (for example)
as 3.75.  It's just the textbox that rounds the number!- Hide quoted text -

- Show quoted text -

Thanks guys; I'll give it a try.
alex

 

[Howard Burgman]

Hello,

using Access '03...

I have a form with two textboxes. One for entering a number and one
for displaying a number.

I'm trying to format them to display the exact number as it's
entered. I've tried adjusting the format, but it's not working.

For example:
I enter 9.5 and the textbox displays 9.50. I could use #.0 in the
format box, but then if I enter 5.75, it will truncate or round.

Also, I'd like .5 to be displayed as .5 and not 0.5.

For some reason my table will display/hold 9.5 as 9.5, it's just my
form. The table datatype is single.

thanks,
alex