Using a Macro to skip lines (1 Viewer)

[Rick_Browne]

Hi all,

I am building a database to log faults in my IT department

The resolution field has several buttons to add things like date stamps and messages.

I use a macro to do this-

Item=

[Forms]![MainLog]![Resolution]

Expression=

[Forms]![MainLog]![Resolution] & "  " & Now()

The problem is this adds the stamp to the end of the existing line, I want it to leave a few line spaces, how can I use this macro to 'press return' after the command is used so that the next addition starts on a new line?

 

[FlyerMike]

Are you really doing this through a macro, or are you using VBA code?

In VBA code, I use either:
VBA.vbNewLine, or
VBA.Chr(13) & VBA.Chr(10) (Carriage Return and Line Feed)

...in order to add blank lines to a log file or Message Box.