Only first digit of a number shows on Report i.e., 600 shows 6

  • Thread starter Thread starter ADB_Seeker
  • Start date Start date
A

ADB_Seeker

My form has a combo box from which I select a three-digit number (shop code).
It shows as a three-digit number in the form, however when I run the report,
which gets its information from the active record in the form, only the first
digit is shown.
(i.e., 600 shows 6, 550 shows 5)

I put 000 in the Format property and this put two zeros in front of the one
number that does show. I tried General Number and got the two zeros after a
decimal point.
My Control Source for the report text box is: =Forms![FIND ER 2]![SHOP
NUMBER].
Shop Number is set up in my table [ER TABLE] as Numeric, on the form as
combo box, and on the report as a text box.
Thank you in advance for your help.
Linda
 
It all starts with the data (not the form or report...)

Go back to the underlying table and confirm that what is actually being
stored is "600", not "6".

NOTE! what is being stored is NOT necessarily HOW it is being
formatted/displayed. Confirm the storage value, not the formatting.

Regards

Jeff Boyce
Microsoft Access MVP


--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
I didn't think to look there. It is being stored as a single digit. My field
settings are Data Type: Numeric
Field Size: long integer
Default: (nothing)

What changes do I need to make to have the entire number stored?

Jeff Boyce said:
It all starts with the data (not the form or report...)

Go back to the underlying table and confirm that what is actually being
stored is "600", not "6".

NOTE! what is being stored is NOT necessarily HOW it is being
formatted/displayed. Confirm the storage value, not the formatting.

Regards

Jeff Boyce
Microsoft Access MVP


--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


ADB_Seeker said:
My form has a combo box from which I select a three-digit number (shop
code).
It shows as a three-digit number in the form, however when I run the
report,
which gets its information from the active record in the form, only the
first
digit is shown.
(i.e., 600 shows 6, 550 shows 5)

I put 000 in the Format property and this put two zeros in front of the
one
number that does show. I tried General Number and got the two zeros after
a
decimal point.
My Control Source for the report text box is: =Forms![FIND ER 2]![SHOP
NUMBER].
Shop Number is set up in my table [ER TABLE] as Numeric, on the form as
combo box, and on the report as a text box.
Thank you in advance for your help.
Linda
Click to expand...


.
Click to expand...
 
"Being stored as a single digit" ... hmmm, does that mean it has "6"?

An "integer" is a whole number. 600 is a whole number.

What happens when you change that to "600"?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

ADB_Seeker said:
I didn't think to look there. It is being stored as a single digit. My
field
settings are Data Type: Numeric
Field Size: long integer
Default: (nothing)

What changes do I need to make to have the entire number stored?

Jeff Boyce said:
It all starts with the data (not the form or report...)

Go back to the underlying table and confirm that what is actually being
stored is "600", not "6".

NOTE! what is being stored is NOT necessarily HOW it is being
formatted/displayed. Confirm the storage value, not the formatting.

Regards

Jeff Boyce
Microsoft Access MVP


--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


ADB_Seeker said:
My form has a combo box from which I select a three-digit number (shop
code).
It shows as a three-digit number in the form, however when I run the
report,
which gets its information from the active record in the form, only the
first
digit is shown.
(i.e., 600 shows 6, 550 shows 5)

I put 000 in the Format property and this put two zeros in front of the
one
number that does show. I tried General Number and got the two zeros
after
a
decimal point.
My Control Source for the report text box is: =Forms![FIND ER 2]![SHOP
NUMBER].
Shop Number is set up in my table [ER TABLE] as Numeric, on the form as
combo box, and on the report as a text box.
Thank you in advance for your help.
Linda
Click to expand...


.
Click to expand...
Click to expand...
 
Yes, the table contains a 6 - not 600. I manually replaced the 6 with 600 in
the table. It still shows up as 6 in the report.
FYI... I have another table Shop Code Table that stores the shop numbers.
This is where the combo box gets its drop-down list.

Jeff Boyce said:
"Being stored as a single digit" ... hmmm, does that mean it has "6"?

An "integer" is a whole number. 600 is a whole number.

What happens when you change that to "600"?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

ADB_Seeker said:
I didn't think to look there. It is being stored as a single digit. My
field
settings are Data Type: Numeric
Field Size: long integer
Default: (nothing)

What changes do I need to make to have the entire number stored?

Jeff Boyce said:
It all starts with the data (not the form or report...)

Go back to the underlying table and confirm that what is actually being
stored is "600", not "6".

NOTE! what is being stored is NOT necessarily HOW it is being
formatted/displayed. Confirm the storage value, not the formatting.

Regards

Jeff Boyce
Microsoft Access MVP


--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


My form has a combo box from which I select a three-digit number (shop
code).
It shows as a three-digit number in the form, however when I run the
report,
which gets its information from the active record in the form, only the
first
digit is shown.
(i.e., 600 shows 6, 550 shows 5)

I put 000 in the Format property and this put two zeros in front of the
one
number that does show. I tried General Number and got the two zeros
after
a
decimal point.
My Control Source for the report text box is: =Forms![FIND ER 2]![SHOP
NUMBER].
Shop Number is set up in my table [ER TABLE] as Numeric, on the form as
combo box, and on the report as a text box.
Thank you in advance for your help.
Linda


.
Click to expand...
Click to expand...


.
Click to expand...
 
The combo is pulling at least two fields, one is bound to the table and the
other is displayed.
In the SQL for the report include the source table used for the combo by
joining on the field of the combo that is bound.

--
Build a little, test a little.


ADB_Seeker said:
Yes, the table contains a 6 - not 600. I manually replaced the 6 with 600 in
the table. It still shows up as 6 in the report.
FYI... I have another table Shop Code Table that stores the shop numbers.
This is where the combo box gets its drop-down list.

Jeff Boyce said:
"Being stored as a single digit" ... hmmm, does that mean it has "6"?

An "integer" is a whole number. 600 is a whole number.

What happens when you change that to "600"?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

ADB_Seeker said:
I didn't think to look there. It is being stored as a single digit. My
field
settings are Data Type: Numeric
Field Size: long integer
Default: (nothing)

What changes do I need to make to have the entire number stored?

:

It all starts with the data (not the form or report...)

Go back to the underlying table and confirm that what is actually being
stored is "600", not "6".

NOTE! what is being stored is NOT necessarily HOW it is being
formatted/displayed. Confirm the storage value, not the formatting.

Regards

Jeff Boyce
Microsoft Access MVP


--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


My form has a combo box from which I select a three-digit number (shop
code).
It shows as a three-digit number in the form, however when I run the
report,
which gets its information from the active record in the form, only the
first
digit is shown.
(i.e., 600 shows 6, 550 shows 5)

I put 000 in the Format property and this put two zeros in front of the
one
number that does show. I tried General Number and got the two zeros
after
a
decimal point.
My Control Source for the report text box is: =Forms![FIND ER 2]![SHOP
NUMBER].
Shop Number is set up in my table [ER TABLE] as Numeric, on the form as
combo box, and on the report as a text box.
Thank you in advance for your help.
Linda


.
Click to expand...


.
Click to expand...
Click to expand...
 
If your report is still showing 6, is there a chance that you have not
refreshed your report? That is, are you looking at a report you ran before
making the change? What happens if you close down your application, launch
it again, and try to re-run that report?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

ADB_Seeker said:
Yes, the table contains a 6 - not 600. I manually replaced the 6 with 600
in
the table. It still shows up as 6 in the report.
FYI... I have another table Shop Code Table that stores the shop numbers.
This is where the combo box gets its drop-down list.

Jeff Boyce said:
"Being stored as a single digit" ... hmmm, does that mean it has "6"?

An "integer" is a whole number. 600 is a whole number.

What happens when you change that to "600"?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

ADB_Seeker said:
I didn't think to look there. It is being stored as a single digit. My
field
settings are Data Type: Numeric
Field Size: long integer
Default: (nothing)

What changes do I need to make to have the entire number stored?

:

It all starts with the data (not the form or report...)

Go back to the underlying table and confirm that what is actually
being
stored is "600", not "6".

NOTE! what is being stored is NOT necessarily HOW it is being
formatted/displayed. Confirm the storage value, not the formatting.

Regards

Jeff Boyce
Microsoft Access MVP


--
Disclaimer: This author may have received products and services
mentioned
in this post. Mention and/or description of a product or service
herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with
no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


My form has a combo box from which I select a three-digit number
(shop
code).
It shows as a three-digit number in the form, however when I run the
report,
which gets its information from the active record in the form, only
the
first
digit is shown.
(i.e., 600 shows 6, 550 shows 5)

I put 000 in the Format property and this put two zeros in front of
the
one
number that does show. I tried General Number and got the two zeros
after
a
decimal point.
My Control Source for the report text box is: =Forms![FIND ER
2]![SHOP
NUMBER].
Shop Number is set up in my table [ER TABLE] as Numeric, on the form
as
combo box, and on the report as a text box.
Thank you in advance for your help.
Linda


.
Click to expand...


.
Click to expand...
Click to expand...
 
Hi, Jeff
I refreshed the report, closed down the application, launched it again, and
ran the report again with the same results. Only one digit shows up on the
report.
 
Hmmm? I'm trying to run through the possibilities in the order of
probability...

How wide is the control on the report? Is it right/left justified? Is
there a format applied, or a mask?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Is it possible that the field (or control) is set to a Percent format, with
no decimal places?

Rob
 
Hello Linda,

I'm presuming you have a shop code table that lists all the shop codes you
use. It should look like:
TblShopCode
ShopCodeID
ShopCode

First, look at what is stored in that table. Are they three-digit numbers?
If so, your shop code data is okay and the form you used to populate that
table works fine.

Now, create a query named QryShopCode based on TblShopCode. Include both
fields in the query. Set ShopCode to sort ascending.

Next, open your form that has the combo box in design view and select the
combobox. Open properties. Go to the Data tab and set the Bound Column
property to 1. Go to the Format tab and and set Column Count to 2 and set
Column Width to 0;1.

Now the combobox on your form will be correct.

Your shop code data in the table that the form is based on is wrong and you
will have to use the combobox to reenter all the shop code data.

Now for the report .........

Create a query based on the current record source of the report and add
TblShopcode to the query. Include all the fields except what you have for
ShopCode you currently use in the report and add ShopCode from TblShopCode.
(Note.. Don't add ShopCodeID). Now open your report in design view and set
the recordsource property of the report to the query you just created. Selet
the textbox and set the contrp; source to ShopCode.

Your report should now work fine!!

Steve
(e-mail address removed)
 
Back
Top