Word format (2000)

Topic

New Reply

I have a field, which will be used for a mail merge letter. How do I make sure that the first letter is in caps.

ContactName

Reply | Quote

Replies

I would create the merge linking to a query. For your query, I would make a field as such:

ContactName: StrConv([ContactName],3)

If you wish to keep your data in whichever case it is in your table. If you want to fix the problem from the get-go, use an update query:

Field: ContactName
Update To: StrConv([ContactName],3)

You can change the number to change the case

1- ALL CAPS
2- all lower case
3- Proper Case

Reply | Quote

Big help – thanks!

Reply | Quote

Jeremy’s suggestion should do the trick, but it is also possible to set the format in Word:
– Right-click the merge field in Word and select Toggle Field Codes from the popup menu.
– The field will look like this:

{ MERGEFIELD Fieldname * MERGEFORMAT }

– Edit it to look like this:

{ MERGEFIELD Fieldname * FirstCap * MERGEFORMAT }

– Press F9 to hide field codes and update the field.

Reply | Quote

Hans,
Thanks for that tip! I didn’t know you could format the fields in word – I’ve always done it in the Access or Excel word document!

Reply | Quote

It can be very useful. Sometimes you cannot do anything about the format in the data source, for example because it is read-only.

Reply | Quote

This works great! Thank you very much.

Reply | Quote