I have three fields in a table. FirstName; SecondName and LastName. In a query, I create a merged field called FullName: [FirstName] &” “&[SecondName]&” “&[LastName]
When I display the FullName field on a form, I wish to show the LastName part only of the merged field in upper case. I have formated the LastName field in the Table to Upper Case (Using > in format field), but get Sentence case on my form for the whole field. I notice that the data has actually been entered (or more correctly imported from Excel) with all three fields having an initial capital letter, ie Sentence case)
Any ideas on clever ways to force the third part of my merged field to all capitals? or as Bold Font perhaps? Would appreciate the reply.
