Adding more than one pre-written statement to the same Text Box

[PBCN]

I'm not sure what you would call what I want to do so Ill try and explain it.

I know I can add a pre-written statement to a Text Box by using Me.TextBoxName.Value = "what I want written in there"



But what I want to be able to do in a Long Text Box, is to be able to add multiple pre-written statements without removing the other line already in there, and each new statement be staring on a new line, like is if I pressed enter after the last statement.

Even if someone wants to tell me what the action I am trying to do is called I will try and find the solution myself.

[isladogs]

Its called concatenation.
If for example you have 3 text strings
Str1= "Hello world."
Str2 ="Bazooka"
Str3 ="Goodbye"
Then you can use Me.Textbox.Value = str1 & str2 & str3
The .Value is optional as its the default property
if you want spaces and/or full stops between each item, then
Me.Textbox= str1 & " " & str2 & ". " & str3

[PBCN]

Ok Ill look into it thanks

[CJ_London]

if your textbox already has text in it and you want to append use

Me.Textbox.Value = Me.Textbox.Value & str3

or

Me.Textbox.Value = str3 & Me.Textbox.Value

depending on whether str3 text is to appear at bottom or top

[rpeare]

p.s. You stated in your original post you wanted the 'result' field to be long text. Manipulating long text fields is notoriously difficult and you may find no matter what you do your 'long text' field is going to start lopping of characters after the 255th place. Be forewarned!

[PBCN]

using @ajax solution I have got this to work how I want it

Me.testbox.Value = Me.testbox.Value & vbCrLf & "testmore"

So far no issues as warned by @rpeare ...............so far

now the next challenge to insert accumulating numbers in front of each line.

[PBCN]

actually that was easier than I thought
I added another cell called 'testnumber' to store a number in and then used the code below

Dim num As String
Dim netnum As String


num = testnumber
netnum = num + 1
If Me.testnumber.Value = 0 Then
Me.testbox.Value = Me.testbox.Value & netnum & ". " & "testmore"
Else
Me.testbox.Value = Me.testbox.Value & vbCrLf & netnum & ". " & "testmore"
End If
Me.testnumber = netnum

[ArviLaanemets]

Of-course you can do as you like, but when you save some test data in such way, then I don't see any difference when you simply delete and forget those data! When you really have lot of test results stored in this way, then it will be practically impossible to make any data mining or analyze on your table!

What is the reason you didn't choose more conventional way to store those data? E.g. you have tables:
tblDevices: DeviceID, DeviceName, ...
tblDeviceTests: TestID, DeviceID, [DeviceTestNo], TestResult

Now, when you have e.g. form where you select a device and can see info about this device (fDevices), you can have a continuous subform in it with all test results for this device (you link the form and subform through DeviceID). Even more, registering new test results is then done simply adding a new record into subform - it will be automatically linked with active device.
And whenever you want e.g. count specific result for given device, or for all devices, or for specific device class, or over certain time period - a simple report based on simple query will do that without a need for heavy coding.

[PBCN]

I think I understand what you are saying, having a filtered continuous subform from another table on the form showing each individual line, which is what I intend to do with some parts of the overall app.

But the data ill will be using in these cells is basically data that is only going to be inserted into reports, which then are handed onto other people to tell them "xyz". Its not data that I will need to look up/analyze later on.