Stop vbProper case happening

[Brian1960]

Hi,
I have some users who have a capital in their name. E.g MacDougall, FitzRoy etc.

Whenever these are in a report it coverts them to Macdougall or Fitzroy.

Is there a function to stip it fixing the text, which is correct in the database.

Thanks

Brian

 

[Brian1960]

Sorry stupidity sets in

I must be getting old or senile.
The problem was not in the report but how the data was stored on the form in the background.