Memo field

  • Thread starter Thread starter bob
  • Start date Start date
B

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
 
Add a carriage return and line feed, like this:
Me.DescriptionCollection = DescriptionCollection + vbCrLf &
Format(Me.PricePaid, "Currency")
 
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
 
Thanks Allen that works fine.

Bob
Allen Browne said:
Add a carriage return and line feed, like this:
Me.DescriptionCollection = DescriptionCollection + vbCrLf &
Format(Me.PricePaid, "Currency")
Click to expand...
 
Back
Top