I have Access 2003 installed, and I have a create table Query which hast first name, last name, and 2 computed fields firstLastName and LastFirstName.
In a report I want to show sometimes (according to the user's choice) the first name + the last name OR the last name + the first name. So I used an unbounded box and bind it in the Detail_Format of the report.
I noticed that if I use a computed field, it comes with an error message that it doesn't recognise this field, but if I use a normal field name (not computed), it functions ok.
I use a query as a RecordSource of the Report. This query uses the created tabel (through the make table Query) as its source.
Sounds like a case for iif inthe query to me
UsersName: iif(booFlag,[Surname] & " " & [Forename],[Forename] & " " & [Surname])
where booflag is a boolean flag derived from your table indicating if the customer wants surname first (true) or forenames first (false)