If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Only first digit of a number shows on Report i.e., 600 shows 6
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 |
#2
|
|||
|
|||
Only first digit of a number shows on Report i.e., 600 shows 6
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" wrote in message news 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 |
#3
|
|||
|
|||
Only first digit of a number shows on Report i.e., 600 shows 6
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" wrote: 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" wrote in message news 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 . |
#4
|
|||
|
|||
Only first digit of a number shows on Report i.e., 600 shows 6
"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" wrote in message ... 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" wrote: 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" wrote in message news 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 . |
#5
|
|||
|
|||
Only first digit of a number shows on Report i.e., 600 shows 6
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" wrote: "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" wrote in message ... 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" wrote: 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" wrote in message news 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 . . |
#6
|
|||
|
|||
Only first digit of a number shows on Report i.e., 600 shows 6
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" wrote: 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" wrote: "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" wrote in message ... 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" wrote: 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" wrote in message news 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 . . |
#7
|
|||
|
|||
Only first digit of a number shows on Report i.e., 600 shows 6
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" wrote in message ... 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" wrote: "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" wrote in message ... 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" wrote: 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" wrote in message news 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 . . |
#8
|
|||
|
|||
Only first digit of a number shows on Report i.e., 600 shows 6
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. "Jeff Boyce" wrote: 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 |
#9
|
|||
|
|||
Only first digit of a number shows on Report i.e., 600 shows 6
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. "ADB_Seeker" wrote in message ... 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. "Jeff Boyce" wrote: 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 |
#10
|
|||
|
|||
Only first digit of a number shows on Report i.e., 600 shows 6
Is it possible that the field (or control) is set to a Percent format, with
no decimal places? Rob Jeff Boyce wrote: 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 "ADB_Seeker" wrote in message ... 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. "Jeff Boyce" wrote: 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 |
|
Thread Tools | |
Display Modes | |
|
|