Print conditional formatting

[Kayleigh]

I have code to export my (datasheet) form to RTF format which works nicely. However the conditional formatting is not showing up. Is there anything I can add to this?

Private Sub cmdExport_Click()

   Dim Fldr As String

   With Application.FileDialog(4)
      .AllowMultiSelect = False
      If .show <> -1 Then Exit Sub
      Fldr = .SelectedItems(1)
   End With
  
DoCmd.OutputTo acOutputForm, Me.Name, acFormatRTF, Fldr & "\" & Me.txtTitle & ".rtf", True, , , acExportQualityPrint

End Sub

 

[theDBguy]

I could be wrong, but I think you can only export the data, not it's formatting.

If you want to format the exported data, you will probably have to do it one row at a time.

 

[Kayleigh]

RTF is easily editable in a Word application. Was considering Excel as well possibly.

 

[Kayleigh]

So conditional formatting would be possible when exporting to Excel?