DEFAULT VALUE QUESTION

[steve goodrich]

I have a form with two memo fields which I would like to add a default
sentence to when a new record opens. I can do this in the memos property
sheet ok but, is there a way I can force the sentence on two or three rows
instead of just one. Or is there a better way of achieving this (without
code please - still learning)
many thanks
Steve Goodrich

 

[Baz]

I have a form with two memo fields which I would like to add a default
sentence to when a new record opens. I can do this in the memos property
sheet ok but, is there a way I can force the sentence on two or three rows
instead of just one. Or is there a better way of achieving this (without
code please - still learning)
many thanks
Steve Goodrich

Set your Default Value property to something like this:

"Line 1" & Chr(13) & Chr(10) & "Line 2"

 

[steve goodrich]

Hi
Thanks for the help, It works ok but I don't understand why. Could you tell
me the reason for typing - chr(13) and chr(10)
Thanks
Steve

 

[fredg]

Hi
Thanks for the help, It works ok but I don't understand why. Could you tell
me the reason for typing - chr(13) and chr(10)
Thanks
Steve

You said you wanted the text on several lines. chr(13) & chr(10) (in
that order) tells Access to make a new line. chr(13) tells it to go
back to the left margin of the control. chr(10) tells it to line feed.
In Access you need both.

 

[steve goodrich]

Thanks for the info, much appreciated