First of all, all credit is due to BBF user murene for this awesome discovery.

BBF user jack55 was looking for a way for the screen to turn on when a text message was received originally here in this thread and murene posted about a program called SMS Display On which does just that.

The program is at a reduced price of $2 (from its regular price of $3) until June 1st and works like a charm. You can adjust the time for how long the screen will light up as well as deactivate the program if you wish. Link to the program is below.

SMS Display ON - Personal Productivity Blackberry Software on MobiHand