without adding all the numbers put them beside of each other

asgare

New member
Local time
Today, 15:29
Joined
Nov 2, 2008
Messages
2
I had a previous experience on working with Access 2003, recently I installed office 2007 but when I start programming on the forms I think none of the codes working.
In my form I have 5 text boxes with the numerical attribute, I need to compose some code and bring all the text boxes values to another text box on the same form.
=======================
Imagine below example:
Text Box 1=Value=5
Text Box 2= Value=12
Text Box 3= Value=87
Text Box 4= Value=89
Text Box 5= Value=11
======================
Now I need the value of “Text Box 6” become “512878911”. Means that without adding all the numbers put them beside of each other.
 
Concatenate

Can you not concatenate the values together?

e.g.

5&12&87&89&11

Should give 512878911
 

Users who are viewing this thread

Back
Top Bottom