Reports Not Right

[terylgirl]

Hello Board,

The reports in my App. are putting a ID number from the table on my report instead of the actual text. Example, I have a table with a status column i.e. (ongoing, complete, on hold) and a status id column with 1-5 for each status. Well, on my reports where I ask for the status, I get the status id number. What can I do to get this to stop and give me the actual text? Thanks!

 

[Dugantrain]

The text box sounds like it's bound to the wrong field. Right click the text box, go to properties, Control Source, and change it to the field that you want it bound to

 

[Corticus]

Do you have the status text in the same table or query as the ID. If so, you should need only to right click on the field of interest with the report in design view, and change the control source property to the field that has the status text.

If the status text is not in the same quary/report as the one to which your report is refering, you will need to add a new query that associates the statusID with its text equivelant, and any other info you need in the report, and have this query be your reports record source. You can then click on the 'field list' icon on Access's main toolbar and drag over the text status field, or insert a blank textbox and set its control source to the status text field.

HTH,