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