DefaultValue

[Guest]

I'm using a text box for notes (it's not associated with any tables). When
user entered some text there I'd like that this text would appear on the next
time when user would open this form.

I'm trying to use the following:
Private Sub N13_AfterUpdate()
Dim strN13 As String
strN13 = Me.N13
Me.N13.DefaultValue = strN13
'Me.N13.Text = strN13 'isn't working as well
'Me.N13.DefaultValue = Me.N13 'isn't working

End Sub
But, it says that the type mismatched.

I'm doing the same for numbers and it's working or when I include the text
in "" manually in a defaultvalue window
Could anybody advise anything?

Thanks

 

[Brendan Reynolds]

Private Sub Text16_AfterUpdate()

Me!Text16.DefaultValue = Chr$(34) & Me!Text16 & Chr$(34)

End Sub

.... where 'Text16' is the name of your text box.

Chr$(34) returns the quote character.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Guest]

Thanks a lot, Brendan.

Private Sub Text16_AfterUpdate()

Me!Text16.DefaultValue = Chr$(34) & Me!Text16 & Chr$(34)

End Sub

.... where 'Text16' is the name of your text box.

Chr$(34) returns the quote character.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.