Inserting an Access Database Field into a string of text.

[Mcoleman]

Hi guys, First post here, so please be gentle.

I'm currently writing an Access 2000 Database, and as part of that I need some reports to make use of the information contained in the db.

The reports are largely written and although i'm not a DB expert, i've so far managed to plod through teaching myself what I need, i've now however hit a bump in the road.

I need to insert a field into some text in a report, and I cannot seem to get it to work without Syntax errors.

The Text is:

"The letter has been passed to [Caseworker] who will note its contents. No formal reply appears to be necessary to this letter."

The [Caseworker] part is the field I need to be inserted, i've tried using the expression builder, and simply inserting the field into text. Basically i'm stuck.

I have searched the internet, and particularly this site, to no avail.

Any help would be most appreciated.

Thanks

Martin

[ADezii]

Hi guys, First post here, so please be gentle.

I'm currently writing an Access 2000 Database, and as part of that I need some reports to make use of the information contained in the db.

The reports are largely written and although i'm not a DB expert, i've so far managed to plod through teaching myself what I need, i've now however hit a bump in the road.

I need to insert a field into some text in a report, and I cannot seem to get it to work without Syntax errors.

The Text is:

"The letter has been passed to [Caseworker] who will note its contents. No formal reply appears to be necessary to this letter."

The [Caseworker] part is the field I need to be inserted, i've tried using the expression builder, and simply inserting the field into text. Basically i'm stuck.

I have searched the internet, and particularly this site, to no avail.

Any help would be most appreciated.

Thanks

Martin

In the Format() Event, in the Detail Section of your Report, place code similar to this, just make the necessary substitution for txtInsert:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me![txtInsert] = "The letter has been passed to " & Me![CaseWorker] & " who will note its contents. " _
                 & "No formal reply appears to be necessary to this letter."
 
End Sub

[Mcoleman]

Hi again.

Firstly thank you for the response to my question.

However I think maybe I mislead you into thinking i was more adept at report writing or Access than I actually am.

From what you wrote, I understood that I needed to enter this into VB (under "view code" function in Access).

I did this, and it brought several errors.

All I wanted to do was insert a field from my database, into a string of fixed text.

So that it read exactly the same, but with the change to the [caseworker]

maybe i'm being thick though

Thanks again

[matthooper]

It depends on how the tables have been designed.

you will have contact details of the person you are writing to and a case worker assigned to that person. (whether this is in another table and you are using a number to link them) If you link those two bits of information using a query, use the query as a source for the report and within a text box use:

="TEXT" & [caseworder/fieldname] & "Continue text"

I hope this makes sence