Hi I want to make Access automatically merge two fields together to create another field.
E.g. I want the First Name (first letter of it) and the surname to be merged together in a form and placed in a new text box or other field. So if the name was David Wild, the result would be DWild.
I understand this will probably use VB programming, which I know a little bit about. I have thought of doing this:
me.text14.value = val(mid(me.firstname,1,1)
but unsure where to go from here in order to add the last name to it.
Thanks
E.g. I want the First Name (first letter of it) and the surname to be merged together in a form and placed in a new text box or other field. So if the name was David Wild, the result would be DWild.
I understand this will probably use VB programming, which I know a little bit about. I have thought of doing this:
me.text14.value = val(mid(me.firstname,1,1)
but unsure where to go from here in order to add the last name to it.
Thanks
