charles
Posts: 59
|
| Posted: 04/04/2007, 12:02 AM |
|
Hi All,
i am trying to concatenate the values of the firstname and surname field into a field fullname in a record form called student1.it works ok except that there is no space between the two field values.for example, if the value in first name is charles and the value in surname is John,
the fullname field is charlesjohn.I need it to put space between the first and surname, for example, charles john.
here is my before build insert code
dim first_name
dim surname
first_name=request.Form("first_name")
surname=request.form("surname")
student1.full_name.value=( first_name & surname)
Can someone kindly point out what could be wrong?
Regards,
Charles
|
 |
 |
amcfadyen
Posts: 8
|
| Posted: 04/04/2007, 1:30 AM |
|
Hi Charles
A space can't be implied in your code, so you have to be specific.
Try: student1.full_name.value=( first_name & " " & surname)
Good luck!
Alistair
|
|
|
|
charles
Posts: 59
|
| Posted: 04/04/2007, 11:30 AM |
|
Thanks alistair,
Using the code as adjusted by you has yielded the desired result.
Thanks for your response.
Regards,
Charles
|
|
|
|
|
