Hi all,

I've run into a case of what you'd call "database developer's block". That is, I know what I want to do but I don't know how to to accomplish it.

I have a report called "Online Music" that I use inside my Music Inventory 2001 application to track music that was listened to. I have a field called "Listen Date" that stores the date that a particular song was listened to.
    I want to have a message show up in the Listen Date field for those records whose "Listen Date" value is null. I'm thinking the message should be "No Date Specified". Is it possible to do this in VBA?

Thanks,



Ben Horne
Madison Area Technical College student
-------------------------
http://community.webshots.com/user/valerian114

Go there. I have a lot of awesome photos that I rendered myself

__________________
Ben Horne
-------------------------
I don\'t want to sound like I haven\'t made any mistakes. I\'m confident I have.

Most likely using FireFox and concocting my next Macromedia Flash project
Snibworks Forums Moderator

Welcome to the New Age

On your report, in the control source for your field Listen Date, use the following:

=iif(isnull([Listen Date]),"No Date Specified",[Listen Date])

If it's null, it will list your text. Otherwise, it will display the date.

Regards,

Beth M

Beth,

Thanks so much for your help. I did run into a few small problems but those have been taken care of and everything is functioning normally.

I already had a Listen Date textbox in the report prior to my first post so when I went in to make the changes to the "Online Music" report, the text boxes overlapped so I ended up getting rid of the original textbox and replacing it with a new one.

Thanks again,


Ben Horne
Madison Area Technical College student
-------------------------
http://community.webshots.com/user/valerian114

Go there. I have a lot of awesome photos that I rendered myself

My pleasure :)