Insert row via vbscript

Posted by: mjstraka on 4 August 2017, 2:35 pm EST

  • Posted 4 August 2017, 2:35 pm EST

    is there a script that will allow me to insert a balnk row into my detail section when the data meets my criteria?
  • Replied 4 August 2017, 2:35 pm EST

    By Blank I'm guessing you mean add white space between rows and that you've got a good reason for not using the group headings and footers.  The only thing I can think of is try changing the .top property of each control in the detail section to Field1.height, then change them back where your condition warrents. 
    (Okay so it's a little goofy but it will work)

    I've also manipulated my data to include blank records in specific loctions in my recordset when necessary.  Just a couple ideas...

    Good luck.

  • Replied 4 August 2017, 2:35 pm EST

    Thanks for the resonse.  I've tried some of those options and for various reasons wernt quite what I was looking for.  I found the soulution using LayoutAction property

    layoutaction = 2

    Thanks again
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels