How to add Row number in MEMO field in a report?

[Elad]

Hi,



I have a report that has a memo field with a few paragraphs.
I want to add row numbers on the side, preferably the first row and then every 5 rows (1, 5, 10, 15...).
I don't know VB but if you have a solution that requires programing I can ask a friend to help out.

Any ideas?
Tnx in advance,
Elad

[June7]

What do you mean by 'row' - a record? Or each line in the memo textbox?

[Elad]

each line.

[June7]

IMO, what you ask for would be EXTREMELY difficult to accomplish. So difficult I would never even try.

What purpose would this numbering serve?

Why does this field have paragraphs?

[Elad]

It's a report that shows a text and then some questions. It's a Reading Comprehension quizz, and I need the line numbers on the side of the text because in some of the questions the line number is mentioned (as reference).
Up untill now I did it in WORD but now I transferred everything to access, it is easier and saves editing time (when I need to edit 50 passage based reading quizzes).

[June7]

Doesn't alter my assessment.

Suggest you annotate the numbers into the memo content, like footnote notation.

[Elad]

Worst case I can enter every line into a different row, I wanted to avoid that...

[June7]

Another approach is to type the text with forced CrLf where you want each line to break and type in numbers and spaces to align as you wish.

[Elad]

Yup, it just makes everything much more complicated.
I'll do it one way or the other.
Tnx again for your help

[CJ_London]

the problem you will have is if the width of the control changes or the font or font size changes (e.g. from form to report), potentially so can the number of rows.

If you are using a memo field, rather than referring to a row number, why not use highlighting or change font colour or style?

But here is another thought. Rather than embedding the row number in your text, have a separate control with the same font etc but sized say two characters wide and with a source of

"01" & vbcrlf & vbcrlf & vbcrlf & "05"  & vbcrlf & vbcrlf & vbcrlf & vbcrlf & "10" & .....

set the control to the left of your memo control and the same height.

[Elad]

Thank you it works!!!
Such a simle and elegant solution, easier than any others and no code was needed.
Frankly, I'm a little disappointed I did not think of it myself, but it's like Columbus's egg...
Tnx

[June7]

As Ajax stated, the line breaks could change if the memo textbox is resized but I guess once you have it set properly should never have need to change. I am also disappointed I did not think of this. Oh well, glad you have a solution.