Why won't any report I generate display an integer value for a numeric field in a table. It displays the contents of the other fields in the table and when I look at the table it shows that each record has a value in the field. I've looked at the properties for the control for that particular field and don't see anything that would prevent an integer from being displayed.

And the control is definitely visible? Is it a combo box or a list box?

it is a list box.

I think your list box has more than one column. Check the row source to confirm. If it does look at the Column Widths and Column Count properties.

I'll check, on the report, but in the table it looks like it is just an integer. FYI: i use this field to enter the "quantity" of an item described in that table record...it is regular number with 0 decimal places, I've tried making it 1 decimal place and then in the data table it shows every number as x.0 i.e. 1.0, 2.0, 3.0

The properties in the table it says list field.

I was referring to the properties of the list box on the report.

it was set to table/query, bound column 1

The Column Widths and Column Count properties as earlier mentioned. What are those?

I don't see where it says list box or combo box anywhere on the properties of the Report.

it is a list box on the table field, I used the report wizard and selected the field to create the report, so wouldn't it by default be a list box on the report?

column count is 1
column heads is no
Visible is "yes"
width 1.6"
height 1.6"
backcolor 16777215 (this is the same as the other fields that I can see)


data settings are as follows

Data Settings follow:

Cntrl source......lngzQty
Row Source Type.......Table/Query ( tried changing to value list, and field list, but then it just displayed the field name "IngzQty" for every record on the report.

Row Source..........tbleItems (the table that contains the other fields that do display properly)
Bound column.....1

I don't know what I changed....but now it is displaying on the printed report.....properly......geeze.......

Faith healing works wonders...........I guess......

You're misinterpreting what I'm relaying to you. Re-read my post #4. :)

it is a list box on the table field, I used the report wizard and selected the field to create the report, so wouldn't it by default be a list box on the report?You can see your report, is it a listbox on the report? I believe you had already confirmed that or were you referring to something else. What is the Listbox's Column Width property?

Like I said....I don't know if by typing in the settings to you that somehow it changed...but for whatever reason....it now displays the integer field value.......properly on the report.........thanks so much for you patience and help.

Grand! Glad you got it sorted.

The Column Width property of a list box or a combo box is what you can use to set which columns in the control should be visible or not.

Of course it looks like I was wrong again....it is displaying the current record number (on every record's line in the qty field) ....and not the quantity value of the record......sheeze.......

I don't even know where it would get that record number to display......unless it is from the tblItems....I entered into the ROW source area...

when I blank out the Row Source.......it goes back to the original problem I had.

Put your cursor on the Row Source property and hit the F1 key.

ok...but I didn't have to do any of this to display the other field values from the table on the report.....

Why would it require me to do this for this particular field?

When you used the wizard to create the report, it sets all of that for you. See how nice the wizard was to you :)

I got it.........Yeah!........Evidently the wizard made it something that looked like a text box.......but actually a combo box...like you said in the beginning......

if I right click on the field......then select "change to" and then select text box.....all is forgiven...and it displays the values that are correct for each record.....

Thanks Mr. Wizard.......(FOR NOTHING)......

Thank you however, for all your help.......and giving me clues......was that on purpose? I'm putting this one in my ..."Oh I can't believe that is how it really works" file.

For something of this nature it wouldn't have been beneficial if I told you exactly what the problem was that was why I wanted you to realise what kind of control you're using and what sort of properties it has. Looks like it paid off because you've learnt from this.

Glad you got it solved. Mr Wizard isn't bad at all. He's a nice chappy if you give him the right instructions :)

Good luck with the rest of your db.

Thanks again......some of the things I learn are more painful than others.....:)

You're welcome ;)