Memo field

[bob]

Hi I have a memo field that I use to collect data from other fields using
the following code.
Me.DescriptionCollection = DescriptionCollection & " " & "£" &
(Me.PricePaid) and so on, there are 4 fields in total.

So we end up with the following in my memo field DescriptionCollection

Data Field 1 Data Field 2 Data Field 3 Data Field 4

I then repeat this process until we have all the data we required from the
4 fields (we over write the data in the 4 fields each time)

What I want to end up with is, every time I enter data into field 1 it
starts on a new line in my memo field DescriptionCollection
instead of following on. Can this be done?

Thanks Bob

 

[Allen Browne]

Add a carriage return and line feed, like this:
Me.DescriptionCollection = DescriptionCollection + vbCrLf &
Format(Me.PricePaid, "Currency")

 

[bob]

Allen thanks for your help that works fine. Thank you also for the
Format(Me.PricePaid, "Currency") that bit works well and I now have the 2
decimal places I needed.
Regards Bob

 

[bob]

Thanks Allen that works fine.

Bob

Add a carriage return and line feed, like this:
Me.DescriptionCollection = DescriptionCollection + vbCrLf &
Format(Me.PricePaid, "Currency")