Search results for query: *

Hi ETID, Thanks! simple and elegant! won't save the space, but I'll use this, so at least we won't have an ugly space in the middle of the report ... :) Bye, Udi (udi_kl@hotmail.com)

Hi ETID, Thanks, tried it now but it doesn't work :( I can't use the <>&quot;&quot;, my query is horribly complex: =IIf([feature_b]=[feature_name] And [feature_a]<>[feature_name],[feature_a],&quot;&quot;) This is actually inside a subreport, and I have another subreport just after this one...

Hi ETID, You are correct. I'm using text box with an IIF(X=Y,A,&quot;&quot;) as a Control Source, and when it fails it introduces the extra space. To be more detailed, I have 3 boxes like that in the same row ..:) I tried to put nothing instead of the &quot;&quot; but still got the extra...

Hi Steve, You can create the stuff in XLS and import it to MS-ACCESS using File->Import... Another idea - if this info repeats for the whole column, consider to simply create additonl table with this info as row and link them. This is probably the correct solution, you'll avoid duplicate...

Hi all, Anyone has an idea how to get rid of extra line spaces in a report? I need to do it after the report is done, not by editing it in a design mode - cause the extra space lines are created dynamically and you can see them only in preview or print modes. So I need something like: sub...

Hi all! Anyone knows how to reference a subreport control or control attribute? either from a VB code defined for event on the main report (e.g. on page) or for event on the subreport (e.g. on open ) is fine. Something like: Report!(&quot;my_subreport&quot;).my_test_box = &quot;xyz&quot...

Hi all, Anyone knows a quick way to convert a form to report? TSI has add-ins to convert form/report to access page but not form to report Thanks! Udi

Hi all, Anyone knows why Microsoft Script Editor does not work? All I get is the frame with no content (I do as they say - open access page in design mode, select an object, right-click and select Microsoft Script Editor .. :) Thanks, Udi

Hi all! Does anyone know how to export MS Access Report automatically to HTML page, whenever its related table is updated? Thanks! Udi