Default text

[mar7632]

Hello everyone,

I have a form in which I have a text field "OBSERVACIONES" (long text). In there, I want to set a default text which appears always when a new record is introduced and can be modified.
I tried to write the whole text in "Default value" but it does not work.

The text has a structure like this:



text .... text:

-text:
-text:
-text:

text ... text.


How can I solve this problem?

Thank you in advance,

Regards.

[June7]

Why did DefaultValue property not work? What did you try?

"text .... text:" & Chr(13) & Chr(10) & Chr(13) & Chr(10) & "-text:" & Chr(13) & Chr(10) & "-text:" & Chr(13) & Chr(10) & "-text:" & Chr(13) & Chr(10) & Chr(13) & Chr(10) & "text ... text."

Otherwise, use VBA in form Current event to populate textbox.

[mar7632]

Thank you for answering, June7

Firstly, my access level is not too high.

I went to Field property in my table and set in "Default value", click at the 3 dots and copy the text between " "
How do I proceed using VBA? Also i tried something like this:

Private Sub OBSERVACIONES_AfterUpdate()
Me.OBSERVACIONES = " text:" _
"-text:"_
"text"_
"text"

End Sub

[June7]

Did you try the expression I show in prior post as DefaultValue?

Don't use OBSERVACIONES AfterUpdate event. That will replace user edits.

As I said, use form Current event. Only want field populated on a new record:

If Me.NewRecord Then
Me.OBSERVACIONES = " text:" & vbCrLf & "-text:" & vbCrLf & "text" & vbCrLf & "text"
End If

Understand that even if user does not edit, that text will still be saved to record.

[mar7632]

Hello!

I have solved the problem in a different way.

What I did was to create a new table called "Table" and with a field called "texto", in there I have copied the whole text I needed.

On the other hand, I have a form in which the field OBSERVACIONES is in there and then I´ve introduced this:

 Private Sub Form_Current()

                If Me.NewRecord Then Me.OBSERVACIONES = Dlookup ("texto", "Table")

End Sub

By using this code when a new record is introduced, the long text appears in OBSERVACIONES and can be modified and keep it.

Regards.