Thanks, that was the ticket. Is this a situation of trailing blanks in the table, but not necessarily trailing blanks in the textbox? It works fine without UPPER() since the data is in uppercase and the controls are formatted for uppercase.
Thanks again,
Matthew>Try
>
>
>local lccurrentrec
>lccurrentrec = thisform.txtClientName.value
>REPORT FORM "d:\client tracker\reports\clientupdate.frx" for ALLT(UPPPER(client.clientname)) = allt(upper(lccurrentrec)) to printer prompt noconsole
>
>I also have found that set eaxact on must be set.
>
>
>
>
>
>
>
>>Hi there,
>>
>>It's late in the day and this has had me stumped all afternoon.
>>I have this code in the click event of a cmdbutton on a form so only the current record will print. The only trouble is that the job goes to the spooler, the printer kicks in, and a blank sheet comes out. If I set it to preveiw, I get a blank screen for a split second. I can preview the report in report designer and all the fields are populated with data. I have a DE set for the report and the form.
>>
>>
>>
>>local lccurrentrec
>>lccurrentrec = thisform.txtClientName.value
>>REPORT FORM "d:\client tracker\reports\clientupdate.frx" for client.clientname = lccurrentrec to printer prompt noconsole
>>
>>What have I left out?
>>
>>Matthew
Opportunity is missed by most people beacuse it is dressed in overalls, and looks like work --- Thomas Edison