By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,561 Members | 3,113 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,561 IT Pros & Developers. It's quick & easy.

Table to Report - Missing Data

P: 2
I am very much a beginner to Access, but learn software very quickly. I made a simple project with a table, a form to enter the data and a report to view/print the data. I added all the data in manually on the table and in my form. When I go to the report print view, some of the textfields have the values in them like in the table, but others are missing the value. I don't see how this is possible seeing as some values are there and others are missing. I am using Access 2007 with Windows Vista. Can someone explain this to me?

thank you.
Oct 13 '07 #1
Share this Question
Share on Google+
5 Replies

Expert 2.5K+
P: 3,072
Hard to diagnose from a distance, but first verify that the fields missing are "bound" to the tablefields. In the textbox of a bound field you'll see the name of the field as defined in the table.
Another option could be that the forecolor property of the reportfield is set to white.

Oct 13 '07 #2

Expert Mod 15k+
P: 31,494
As Nico says, without any information related to what's missing we are working in the dark somewhat. I suggest you take the following steps and, if they don't enable you to see the problem for yourself, describe the results in here and we'll see where we can get to.
  1. Open the underlying table and check that the data entered is indeed stored in your table.
  2. Open your report and note which fields are missing and which are displayed.
  3. Find one of the controls in your report which is NOT displayed and examine the Control Source property.
Also helpful, should you need further help, would be the definition of the fields in the table (known as Table Meta-data). Here is an example of how to post table MetaData :
Table Name=tblStudent
Expand|Select|Wrap|Line Numbers
  1. Field; Type; IndexInfo
  2. StudentID; AutoNumber; PK
  3. Family; String; FK
  4. Name; String
  5. University; String; FK
  6. Mark; Numeric
  7. LastAttendance; Date/Time
Oct 13 '07 #3

P: 2
I understand it is probably hard to see what i'm asking so let me see if I can clarify. I have a table of data such as names numbers and addresses. In my report I have three textfields: 1. Name 2. Number 3. Address. These textfields shoot out all the details of the entries I have so say I have 5 entries in my table. For some reason the report will only show about 2 out of the 5 numbers in the Number category. I checked the control source for the textfield that shoots out the numbers detail and it is referred correctly like i thought. If it displays 3, it should display the other 2. I hope this gives everyone a better idea of my problem. thank you.
Oct 14 '07 #4

Expert Mod 15k+
P: 31,494
Soccery, please read my post again carefully. There are instructions in there of both what you should check and, if that fails to help, what you need to provide in the way of information for us to be able to help you. We may be able to make some further progress if you don't provide this information, but if you were helping someone else and they failed to provide the information requested - would you go the difficult route to try to help them?
Please A - Let us know you're still stuck, confirming that you've followed the suggestions provided already.
And B - Provide all the information requested.
Oct 14 '07 #5

Expert 2.5K+
P: 3,072
Please open the table and copy/paste the five rows here.
Open the report's properties and goto the Controlsource (First entry under Data tab).
Open the controlsource query and switch to the SQL mode to copy/paste the SQLtext and finally switch to the view mode to see the rows and copy/paste those too.

Oct 14 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.