Getting first Char form a Field

[newtoAccess]

I need to get the first char of the field F_Name. For address lables.
Eg Mrs. x Smith I nedd to get the x.
Should I use a query or can I do it directly in a table?
how do I do it?


Thanks

[weekend00]

if you F_Name is like "Mrs. x Smith ", it is a complicated case, because we need a knowledge table about the solutations: MRS. MR. MR MRS DR DR. MS etc. we need to get rid of those solutations and then get the first char.

when you try to get rid of the solutations, please consider:
1 no solutation
2 name may not have space between solutation and name, like "MRS. X smith" and "MRS.X smith"
3 solutation may not have a dot, like "MRS X smith"
4 Is there any case that have two-word-solutation? like "DR MS x smith".

after get rid of the solutation, use left function to get first char:
nName: left(name_without_solutation,1)

[newtoAccess]

They are already seperated fields.

Where do I use Left(FName,1) in a querry or in the main table? or someplae else.
How?
I tried Left("TableNameHere!L_Name",1) and kept getting errors.

[ducecoop]

Not the expert here (I am posting a lot of questions my self)
But
I would make a hidden field called (new field in DB, hidden field on your form)
f_nameLabel

On the "after update" event of the first name field
code
me.f-NameLabel = Left(f_name,1)

when printing your label pull from f_nameLabel not from f_name

hope that helps a little

This is all assuming I understand you correctly the the sirname is in a different field