|
mjmtravel -> Formatting Memo fields in Access (5/21/2009 10:33:25)
|
Hello all
I just had to post this find, it may not be special to everyone, but for those looking for a very simple way to add paragraphs in your access memo fields very easily, this is it. This is a old microsoft work around that works from Front Page 2000, 2002 and 2003.
I have tried the carrage return coding but only received errors with it. My forms are updating a access database and built with the form wizard and not on the spooky diet.
Replace this code on the results pages with the field you want to have paragraphs and put this in its place. It worked for me and was a piece of cake.
Adding Paragraphs in a memo field. This must go in the results page or display page.
Old form field <%=FP_FieldVal(fp_rs,"Description")%>
New replacement <%=Replace(FP_FieldVal(fp_rs,"Description"),vbCrLf,"<br>")%>
|
|
|
|
