Are you trying to actually save concatenated value into table? Why?
An expression in textbox control source can concatenate the data.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
do not know
Do not know what?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Here. This is the module I use all the time. It was written by Terry Kreft and works great.
What do you not know?
How to concatenate?
How to save the concatenated string into table?
You still haven't answered why you want to do this.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
June7, I don't think he knows how to concatenate.
Expression in textbox Control Source property to concatenate data into multi-line string:
=DATA & Chr(13) & Chr(10) & CLIENTE & Chr(13) & Chr(10) & UTENTE & Chr(13) & Chr(10) & PASSWORD & Chr(13) & Chr(10) & SERIALE
What purpose does that serve?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
THANK YOU
Should I do this because I can not find a way to print or copy or exportare data only.
WORK:
=Concat("Data: ",[DATACasellaDiTesto],"Cliente: ",[CLIENTECasellaDiTesto],"Utente: ",[UTENTECasellaDiTesto],"Password: ",[PASSWORDCasellaDiTesto],"Seriale: ",[SERIALECasellaDiTesto])
error if i use
& Chr(13)
"value not valid"
Why are you using Concat(). AFAIK, that is not an intrinsic function. Is it a custom function you built?
Chr(13) & Chr(10) works for me as shown in my example.
The print/export issue addressed in your other thread. How does concatenating data help?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
you test it, on web app?