Why Won't A Field Show Up ???

[italianfinancier]

Hi everyone...i'm stumped! I go to create a list in a report using an Access table and one of the columns (The MEMO Column) isn't available. How do I get it so that the missing column is available for population into my report?

Please see attachments so you can see what I'm seeing...

 

[boblarson]

Why are you adding a listbox for this? A memo field goes in a text box. You can't use it in a list box.

And there are certain controls that don't really belong on a report - among them are a listbox and a combo box.

 

[italianfinancier]

Ahhh, I didn't know that...thanks! Can the other data go in the text box with it?

 

[boblarson]

Can the other data go in the text box with it?

What other data? Normally you have a text box for each field that you want to display on a report and the control's control source is bound to a field in the table or query. What exactly are you trying to display together?

Oh, and just for the correct terminology - Reports and Forms don't have fields on them. They have controls bound to fields. Tables and Queries have fields.

 

[italianfinancier]

The other data are the other columns in the picture...Date, Contact, Entered By, Etc. Ideally I would like the report to show the data just like in the picture, but only display the data related to a single customer # entered by a user.

 

[boblarson]

Just add a text box for each of those fields and then adjust it the way you like it on the report. One thing to note. If you use a query for the report, and it has criteria, you will need to build a query with the criteria but WITHOUT the memo field and then you use that query in another query and you add the table back in and link it up to the applicable fields and then add the memo field in to that second query. Otherwise it will truncate at 255 characters.

 

[italianfinancier]

Cool, I can do that...the last thing holding me up finishing this project is how to get the data on the report to only be data relating to a user-entered customer number on the Form. I have both the Report and Form built, but no matter what I do, all the information in the tables shows in the control box.

Do you know how to do this? Thanks so much for your help...you really know your stuff!

 

[boblarson]

Cool, I can do that...the last thing holding me up finishing this project is how to get the data on the report to only be data relating to a user-entered customer number on the Form.

You can open the report to filter on that selection on the form. Replace the parts in red with your real names:

DoCmd.OpenReport "[B][COLOR=red]ReportNameHere[/COLOR][/B]" , acViewPreview, , "[[COLOR=red][B]CustomerNumberFieldInReport[/B][/COLOR]] = " & Me.[COLOR=red][B]ControlNameWithCustomerNumber[/B][/COLOR]
[B][COLOR=#ff0000]

[/COLOR][/B]

And if CustomerNumber is text it would be like this:

DoCmd.OpenReport "[B][COLOR=red]ReportNameHere[/COLOR][/B]" , acViewPreview, , "[[COLOR=red][B]CustomerNumberFieldInReport[/B][/COLOR]] = " [B]& Chr(34) [/B]& Me.[COLOR=red][B]ControlNameWithCustomerNumber [COLOR=black]& Chr(34)[/COLOR][/B][/COLOR]
[B][COLOR=#ff0000]

[/COLOR][/B]

 

[italianfinancier]

Please see attached...it doesn't pull up the right customer number's data.

 

[boblarson]

So are you sure that there is a space in between the word Customer and the Octothorpe (#)? Also, fields with those type of naming (with special characters) can cause problems.

Second, was the report already open? It would need to be closed first before it will open with the right info.

 

[italianfinancier]

You are the man! It worked without the #. Last question...

Is there a way to set up a report so that if any textbox's size isn't big enough to hold all the data that the user can scroll to the right/left up/down and see the data that didn't "fit"?

 

[boblarson]

Is there a way to set up a report so that if any textbox's size isn't big enough to hold all the data that the user can scroll to the right/left up/down and see the data that didn't "fit"?

There is no "scroll" available like that but you can set the control's CAN GROW property to YES (you also have to set the Can Grow property of the SECTION the control is in to YES as well).

 

[italianfinancier]

Will the CANGROW automatically adjust the rest of the controls on the report downward or simply overlap them so they can't be seen?

 

[boblarson]

Will the CANGROW automatically adjust the rest of the controls on the report downward or simply overlap them so they can't be seen?

It moves everything down accordingly. The next row will start after the text box which has expanded the most. Give it a try and you'll see.