How to ignore caption and it's field in an Access 2010 Report and an Outlook Email wh

[newtoaccessvba]

I am not too familiar with VBA in Access, but I would like if someone could show me how to ignore a caption and it's field in an Access 2010 Report and an Outlook Email when the field value is it is empty.

'Here is some relevant code (next three lines):

Dim DesiredRequiredDate As String
DesiredRequiredDate = Me!DesiredRequiredDate
"Desired Required Date:" & " " & DesiredRequiredDate

'In the body of email, if the value is null/empty, then I do not want the field name to appear in the body of the email, ignored.

[Rabbit]

Please use code tags when posting code.

Use the If Then logic to skip blank fields

If someValue <> "" And Not IsNull(someValue) Then
   'output your data
End If