I remember doing something like this in the past, however now i'm having trouble:
The start/end date just show in the database for courses that are clerkships,
so if the data is present, would like to show the data and color it a light gray
if no date info, then the report should show blank for those filelds.
I gave an example below of a function i coded the Me.txtEndDate (need to do the same for behind Me.txtStartDate)
but for the blank DATES, #ERROR is showing
for the good DATES, it is not coloring gray....
tx for your ideas, and assistance, below is an mdb, sandra
Private Function f100_FormatEndDate(datEndD
ate As Date)
If IsNull(datEndDate) Then
f100_FormatEndDate = vbNullString
f100_FormatEndDate = " - " & Format([End Date], "mm/dd")
Me.txtEndDate.BackColor = 14803425