Thanks again, Paul.

The truncated addresses problem was my fault! As it was only a test I had not filled the table in Access with the complete information! Sorry.

As far as the currency issue is concerned, the cells in the form are not filled with merged data, the idea is that the recipient of the form will enter figures and send the form back to the Treasurer. When I select the cell and press Shift - F9 nothing happens. Is there some other way to make these cells appear as currency when someone enters a figure?

Any more thoughts on the hyperlink problem?