Reverse the display order of names

[Khatuaaccess]

Hi,
I have a filed name called "Name" where I values like "Smith, Will". I now have a need to display the firstname first then
surname ( ex - will smith). Is there a way of reversing the order that the column "name" is
displayed and update it in access table.

Thanks
Prasanta

[orange]

You should store data in atomic form. That is,

tblPerson
FirstName......John
LastName......Smith
other info

You can always concatenate atomic values into other displays when necessary

LastName & ", " & FirstName produces Smith, John

From Michael Hernandez

Elements of the Ideal Field
--------------------------------------
It represents a characteristic of the subject of the table.
It contains only a single value
It cannot be deconstructed into smaller components
It does not contain a calculated or concatenated value
It is unique within the entire database structure
It retains all of its characteristics if it appears in more than one table.

[aytee111]

The main question is - is the name always in that format? If so, then you can take the last name as all characters before the comma and the first name as all characters after the comma. This is dependent on the comma always being there and in that spot.

[Bulzie]

vFirstLastName = Trim(Mid(Me.Name, InStr(Me.Name, ",") + 1)) & " " & Left(Me.Name, InStr(Me.Name, ",") - 1)

fyi you should not use Name as a field name, use FirstName or FName, LastName, FullName, etc. Also as aytee asked, if the format does not always have the comma after the last name, then the line above will not always work.