Integer & text in one text box

[Neil.Cranston]

I am trying to place two fields from a query into a text box on a report. One is an integer and one text, the report will recognise them both separately but not together. I am using

=[Section] & ". " & [SectionTitle]

and would like the result to look like

1. Section Revision list

Can any one suggest where I am going wrong.

Neil

 

[Fornatian]

The reason it isn't working may be because the word Section is a reserved word - it is already used by Access internally. I would first recommend changing that on all tables,queries, forms, reports and modules before you go any further.

If this is the end of the world as you know it, then try:

=CStr([Section] & ". " & [SectionTitle])

to convert it into a string.

Ian

 

[Pat Hartman]

When you use a wizard to create a form/report, the wizard names the control with the same name as its bound controlsource. If you then change the controlsource of one of these fields to concatenate two fields as you have done, you need to change the name of the control so that it is no longer equal to the name of a field from the form's recordsource. So for example if the control name (the Name property on the Other tab) = Section, then change it to txtSectionPlusTitle or xyz. Anything except the name of a field from the recordsource.