Search results for query: *

I got it to work! :o) Since I can't directly feed in the global parameter to the unbound field in a REPORT, I created an unbound field on the FORM and pass in the global parameter to the unbound field and have it hidden... THEN when I open the Report (Unbound), I hard-coded the comments...

I got it to work! :o) Since I can't directly feed in the global parameter to the unbound field in a REPORT, I created an unbound field on the FORM and pass in the global parameter to the unbound field and have it hidden... THEN when I open the Report (Unbound), I hard-coded the comments...

Thanks foolio12 but I don't think by changing the LableBox to the TextBox would help me in this case because I'm using the UNBOUND feature therefore if I use TextBox I'll need to use the SetFocus... and it's not letting me using the SetFocus feature in the REPORT. It only applies in the FORM...

There's a CanGrow properties for the Text Box... Is there a way to set the CanGrow properties for the LABEL (this is NOT address label) in the report? The report is NOT bound to any table, just simply using the SQL queries and passing in a large String to the label. I can't use the Text Box...

Thanks for your suggestion, CosmoKramer. The strMyComments comes from a table with multi-comments and feeds into one big comment, it's like comment history. It's a string and I need to be able to display it in the report into either a TextBox or Label field (be able to hold up to 4,000...

Are you using the MS Query within the MS Excel? If so, you can you write your SQL and give it a parameter in the criteria area. Upon selecting "Refresh Data" it will prompt you for the Start Date and End Date (04-JUN-2003 - format). example: SettlementDate >= [Start Date:]...

Hello, I'm a newbie... 1. What's the max length that can be displayed for the TextBox and Label box (Unbound) in Access? 2. I have a string, 4000 characters long, and would like to store it in either TextBox or Lable field (Unbound). Would this be possible? example...