Carriage Return behavior In memo field

[brharrii]

Access 2010

My form Currently has a memo field that has enter key behavior set to: "New Line in Field". The problem I'm having is that each time I push enter it skips a line so I have double spaces between each carriage return. Is there a way to change this?

Thanks!

 

[llkhoutx]

What are you using for the carriage return (blank line)? I concantenate "vbcrlf" without the quotes.

 

[brharrii]

I'm not sure what you mean? I just push "enter"

 

[llkhoutx]

Are you trying to introduce 1 blank line? or, is control on the memo field and you press enter? If the latter, why is focus on the memo field?

 

[boblarson]

Is this a Rich Text field, per chance?

 

[brharrii]

It isnt, it is plain text. Would it be easier to work with if it was rich text?

 

[boblarson]

It isnt, it is plain text. Would it be easier to work with if it was rich text?

No, I just thought it might have to do with the spacing maybe having something like how Word has BEFORE and AFTER under Paragraph which lets you determine your spacing. Not sure why it would be doing this otherwise.

Just to test, what happens if you change the enter key option back to DEFAULT and then use Ctrl + Enter. Does it do the same spacing?

 

[brharrii]

Are you trying to introduce 1 blank line? or, is control on the memo field and you press enter? If the latter, why is focus on the memo field?

I apologize, My limited vocabulary may make this harder than it needs to be.

Essentially I have a memo field that I use to store special instructions for each of our products. This memo field appears on a form along with all the other pertinant fields to the product. For some reason every time I try to enter information into the special instructions field on the form, it looks like this:

Special instructions

- Step 1

- Step 2

- Step 3


I want them to look like this:

Special instructions
- Step 1
- Step 2
- Step 3

 

[gblack]

I have a similar issue... I was wondering if I could loop through a dataset within a Memo field and grab text values line by line... My problem is I don't know how to code for hard returns or lines... like how do I code to look for (or move to) the next line, take whatever is on that line and then push it into variableX.

Is that even possible? Seems like it should be.

So for simplicity, using brharrii's example: how would I post those three lines into an array without posting the blank lines between?

v/r,
-Gary