Send two Combined text boxes to one field only + empty string 1

[BrenoAguiar]

I'm trying to add an empty string to be sent in this command, so that by using the code below, it will send the two combined text boxes ([text2] and [addnt])and also an EMPTY STRING or a CTRL ENTER (SendKey) to the one field (Notes) in my table "Units".



DoCmd.RunSQL "UPDATE Units SET Notes=[Notes] & [text2] & [addnt] & [space] where [computer code] = '" & Me!compcode & "'"

Thanks Guys!

 

[RoyVidar]

No Sendkeys, please...

What does it do now? Are you looking for something like this?

[tt]... SET Notes=[Notes] & chr(13) & chr(10) & [text2] & [addnt] & [space] ...[/tt]

Roy-Vidar

 

[BrenoAguiar]

Thats Exactly it!

But what the chr(13) and chr(10) means? I guess why 10 and 13?
what i wanted was to skip one line every time a note is entered through this form.

Thanks For the help!

 

[RoyVidar]

13 is Carriage Return, 10 is LineFeed, and both are necessary, in that order, to create linebreaks visible in controls.

Roy-Vidar

 

[BrenoAguiar]

Awesome!

Thanks again ROy!