View Full Version : Using a Macro to skip lines


Rick_Browne
11-01-2005, 02:10 AM
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
11-01-2005, 07:32 AM
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.