Text Field in Report Showing as Number

[LWoods]

Hi All:

I have a report that calculates equipment totals for the month and is grouped on Equipment Type (Text) and sorted by Equipment Name (Text). The report is based on a query that returns the results exactly as I want them; but for some reason, the report is showing the Equipment Type fields as a Number instead of Text.

My first thought was that the Format of the Text field was wrong, but when I try to change it -- it is currently blank -- there are no drop-down options...

Then I thought that maybe the report is picking up on the Equipment Type ID (Autonumber & PK in tblEquipmentTypes), but the numbers that are showing in the report don't correspond with the Equipment Types that are showing up in the report (which, strangely, start at 0).

Any thoughts why this would be happening? I just tried to re-create the report with the Wizard as a quick test and the problem appeared again. Why might this be occurring somewhere between the "perfect" query and the "flawed" report?

Many Thanks!!

-L

 

[ted.martin]

I don;t suppose your field Equipment Type is a Comboor List and the report is picking up the first column 1 field which is a number instead of displaying column 2 which is the text description?

If this is the case, then change the text field properties to:

ColumnCount = 2
BoundColumn = 1
ColumnWidths = 0cm;3cm (say 3cm)

 

[LWoods]

Hi Ted!

Thanks for your reply, but my text field is indeed formatted as a Text Box.

Just in case, I did a quick check and changed it to a Combo Box to view the properties, but they were set correctly.

ColumnCount = 1
BoundColumn = 1
ColumnWidths = null (default)

-L

 

[vbaInet]

I don't see how it would display incorrect data. It's either you're using the wrong field or performing some calculation on the report or in the query.

 

[LWoods]

I don't see how it would display incorrect data. It's either you're using the wrong field or performing some calculation on the report or in the query.

I don't see why it is displaying the text as numbers either -- I've never experienced this problem. To my knowledge, there aren't any special properties on the Equipment Type field, but I can't get it to display the results as they appear in the query.

I've attached screen shots of the design and results for both the query and the report. Hopefully they can show the error better than I can explain it as I cannot release a copy of the db.

Thanks for your help,
-L

 

[LWoods]

Re: SOLVED - Text Field in Report Showing as Number

Hi all,

Just wanted to close out the thread as I discovered what the problem was.

To determine whether the problem was occurring in the query or the report, I created a form based on the query and the Equipment Type text appeared correctly. In the form, Equipment Type was a Combo Box field, so I checked my report and the Equipment Type field was showing as a Text Box. Back to the form to change the Combo Box to a Text Box and that's when the dreaded numbers appeared. Unfortunately, when I tried to change it back to a Combo Box, the numbers were still there.

At some point I must have changed the Equipment Type field to a Text Box, and even though I tried changing the field to a Combo Box, the numbers stuck...

Regardless, I'm just glad to have it working!

Many thanks for the suggestions!
-L

 

[vbaInet]

Re: SOLVED - Text Field in Report Showing as Number

At some point I must have changed the Equipment Type field to a Text Box, and even though I tried changing the field to a Combo Box, the numbers stuck...

That's because the Column Widths and Column Count properties weren't set properly like ted.martin was hinting.

Good to hear you've got it fixed.