Data Not Displaying

[Samantha]

I am having a weird instance with my report not showing a couple of data.
This report is based on a table and has 7 groups. The weird instance is on
group 1, where some of the data appeared but not all. For example, here are
my data :

ColA ColB ColC ColD ....

So far, I have detected that in ColC, the data does not show in all rows.
Ex.: I have 13 rows all together, but in rows 3 and 6, Col C is blank.
I checked the data in the table and they're all there. It is just not
showing up on the report. I checked the Conditional Formating for this
textbox, but there is no conditional formatting setup. What's going on????
Has anyone seen this before??? Help!! Any pointers are very much appreciated!
Thanks a bunch in advance!

 

[Allen Browne]

Perhaps the Hide Duplicates property is set?

 

[Samantha]

Allen thanks for your reply.
I checked the Hide Duplicates property, and it is NOT set.
I even tried deleting the textbox and dragging the field onto the report
again...Same problem. I wonder what's going on??? I'm really pulling my hair

 

[Allen Browne]

Okay, you have established that the problem occurs in row 3, ColC (as one
example.) You might examine the contents of this cell in more detail.

The table that ColC comes from should have a primary key field. For this
example, we will assume the pk is named ID, and the ID field contains the
value 4 on row 3. Open the Immediate Window (Ctrl+G) and ask Access some
questions about the contents of this field on that row. Use DLookup() after
a question mark, e.g.:
? DLookup("ColC", "Table1", "ID = 4")

What does it return? Is there an extra blank line at the start of the result
(i.e. the field begins with a carriage return)? You can ask for the Ascii
character of the start of the field like this:
? Asc(DLookup("ColC", "Table1", "ID = 4"))

How many characters are returned? To see if there are any hidden characters
messing up the data, compare what you see to:
? Len(DLookup("ColC", "Table1", "ID = 4"))

If you open the table in design view, what data type is ColC?

For help with DLookup(), see:
http://allenbrowne.com/casu-07.html