Search results for query: *

Oops !! Give credit where credit is due... I errantly stated that it was mustang8059 who posted info about the Report Definition option; I was incorrect, as it was mustang8097 !!!! My apologies... :-P Regards, =^..^=

Jimbow, that is a known bug in VB and Microsoft has never fixed it. The command button has no "flat" property, either. :-( You will just have to create your own flat combo box control, like I had to do !! :-D Regards, =^..^=

Or, as mustang8059 taught us, go to File...Print...Export...and choose Report Definition. This exports to a .txt file with info about the report, as well as all the code behind your formulas. Pretty cool !! :-D =^..^=

It depends on how you are using/creating the report. As a VBer, I use the NoData() event in Visual Basic code and with that, I tell the user that "there is no data to print..." I then handle it accordingly (I cancel the event by setting Cancel = True and nothing prints). =^..^=

... or, you can name your formula @FormatPhone: Left ({people.tel1}, 3) + "-" + Mid ({people.tel1}, 4,3) + "-" + Mid ({people.tel1}, 7,4) then do the following: If IsNull(@FormatPhone) = True Then "" Else @FormatPhone =^..^=

Thx a bunch, mustang8097 !! This came in handy for me today. Although I have been using Crystal Reports for about 2 years now, I never paid any attention to the "Report Definition" feature; never knew it was there... X-) =^..^=

Article Q245465 in MSDN outlines what afrancoeur has already stated. ;-) =^..^=