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 |
#11
|
|||
|
|||
Only first digit of a number shows on Report i.e., 600 shows 6
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 "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 |
|
Thread Tools | |
Display Modes | |
|
|