Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Alternate colors in report for multicolumn report

Discussion in 'Information Technology' started by millie.patel@gmail.com, Jul 28, 2006.

  1. millie.patel@gmail.com

    millie.patel@gmail.com
    Expand Collapse
    Guest

    Hi All,

    I have a report that has a subreport with 4 columns (Level 1, 2, 3, 4).

    I want the report to alternate colors every row; however, each row may
    have different size values in the columns --
    for example:


    Level 1 Level 2 Level 3 Level 4
    x x x xxx
    xxx xx xxx


    that is one row -- i need it to shade the entire row grey -- and the
    height of the shading to be as long as the Level 4 text.


    Any ideas/suggestions?


    Thanks,


    Millie
     
  2. Loading...

    Similar Threads Forum Date
    Movies Alternate View - Review Of 'PROMETHEUS' Theatre, Movies & Cinema Nov 12, 2016
    Controversial Balkanizing Pakistan; an alternate view Hard Talk Aug 30, 2010
    Sikhi Color Magic - Eminence Of Colors In Gurbani Sikh Sikhi Sikhism Jun 24, 2016
    Four colors of Khalsa? Sikh Sikhi Sikhism Jun 15, 2009
    Colors, chants mark opening of Hindu temple (Houston Chronicle) Interfaith Dialogues Jun 29, 2005

  3. SusanV

    SusanV
    Expand Collapse
    Guest

    Regardless of data - rows are rows:
    http://www.codewidgets.com/product.aspx?key=35
    --
    hth,
    SusanV


    <millie.patel@gmail.com> wrote in message
    news:1150205199.111523.199390@i40g2000cwc.googlegroups.com...
    > Hi All,
    >
    > I have a report that has a subreport with 4 columns (Level 1, 2, 3, 4).
    >
    > I want the report to alternate colors every row; however, each row may
    > have different size values in the columns --
    > for example:
    >
    >
    > Level 1 Level 2 Level 3 Level 4
    > x x x xxx
    > xxx xx xxx
    >
    >
    > that is one row -- i need it to shade the entire row grey -- and the
    > height of the shading to be as long as the Level 4 text.
    >
    >
    > Any ideas/suggestions?
    >
    >
    > Thanks,
    >
    >
    > Millie
    >
     
  4. millie.patel@gmail.com

    millie.patel@gmail.com
    Expand Collapse
    Guest

    When I do that, it highlights just the text in the row -- so if text is
    longer in one column, it is highlighted more --

    The entire row is not highlighted -- only the text


    SusanV wrote:
    > Regardless of data - rows are rows:
    > http://www.codewidgets.com/product.aspx?key=35
    > --
    > hth,
    > SusanV
    >
    >
    > <millie.patel@gmail.com> wrote in message
    > news:1150205199.111523.199390@i40g2000cwc.googlegroups.com...
    > > Hi All,
    > >
    > > I have a report that has a subreport with 4 columns (Level 1, 2, 3, 4).
    > >
    > > I want the report to alternate colors every row; however, each row may
    > > have different size values in the columns --
    > > for example:
    > >
    > >
    > > Level 1 Level 2 Level 3 Level 4
    > > x x x xxx
    > > xxx xx xxx
    > >
    > >
    > > that is one row -- i need it to shade the entire row grey -- and the
    > > height of the shading to be as long as the Level 4 text.
    > >
    > >
    > > Any ideas/suggestions?
    > >
    > >
    > > Thanks,
    > >
    > >
    > > Millie
    > >
     
  5. SusanV

    SusanV
    Expand Collapse
    Guest

    Huh? This should set the background color of the row - not any text
    formatting such as foreground color or bold or any of that. I use it to
    alternate grey and white is several reports as follows:

    '===========
    Private m_RowCount As Long
    '===========
    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    m_RowCount = m_RowCount + 1
    If m_RowCount / 2 = CLng(m_RowCount / 2) Then
    Me.Detail.BackColor = 12632256 'Set to grey
    Else
    Me.Detail.BackColor = 16777215 'This is the white row
    End If
    End Sub
    '===========


    Can you post the entire Detail_Format sub?

    SusanV

    <millie.patel@gmail.com> wrote in message
    news:1150290816.465402.192370@y41g2000cwy.googlegroups.com...
    > When I do that, it highlights just the text in the row -- so if text is
    > longer in one column, it is highlighted more --
    >
    > The entire row is not highlighted -- only the text
    >
    >
    > SusanV wrote:
    >> Regardless of data - rows are rows:
    >> http://www.codewidgets.com/product.aspx?key=35
    >> --
    >> hth,
    >> SusanV
    >>
    >>
    >> <millie.patel@gmail.com> wrote in message
    >> news:1150205199.111523.199390@i40g2000cwc.googlegroups.com...
    >> > Hi All,
    >> >
    >> > I have a report that has a subreport with 4 columns (Level 1, 2, 3, 4).
    >> >
    >> > I want the report to alternate colors every row; however, each row may
    >> > have different size values in the columns --
    >> > for example:
    >> >
    >> >
    >> > Level 1 Level 2 Level 3 Level 4
    >> > x x x xxx
    >> > xxx xx xxx
    >> >
    >> >
    >> > that is one row -- i need it to shade the entire row grey -- and the
    >> > height of the shading to be as long as the Level 4 text.
    >> >
    >> >
    >> > Any ideas/suggestions?
    >> >
    >> >
    >> > Thanks,
    >> >
    >> >
    >> > Millie
    >> >

    >
     
  6. millie.patel@gmail.com

    millie.patel@gmail.com
    Expand Collapse
    Guest

    Option Compare Database
    Private shadeNextRow As Boolean
    Private lastProgression As String
    Private lastProgressionRow As String
    Const shadedColor = 16770273
    Const normalColor = 16777215
    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    If lastProgression <> Me!Progression Or lastProgressionRow <>
    Me!ProgressionRow Then
    shadeNextRow = Not shadeNextRow
    lastProgression = Me!Progression
    lastProgressionRow = Me!ProgressionRow
    End If
    If shadeNextRow Then
    Me.Section(acDetail).BackColor = shadedColor
    Else
    Me.Section(acDetail).BackColor = normalColor
    End If
    If Me!CapabilityColor = "red" Then
    Me!Capability.ForeColor = RGB(255, 0, 0)
    ElseIf Me!CapabilityColor = "orange" Then
    Me! Capability.ForeColor = RGB(255, 140, 0)
    ElseIf Me!CapabilityColor = "green" Then
    Me! Capability.ForeColor = RGB(0, 100, 0)
    ElseIf Me!CapabilityColor = "purple" Then
    Me!Capability.ForeColor = RGB(148, 0, 211)
    ElseIf Me! CapabilityColor = "blue" Then
    Me!Capability.ForeColor = RGB(0, 0, 255)
    End If
    End Sub

    SusanV wrote:
    > Huh? This should set the background color of the row - not any text
    > formatting such as foreground color or bold or any of that. I use it to
    > alternate grey and white is several reports as follows:
    >
    > '===========
    > Private m_RowCount As Long
    > '===========
    > Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    > m_RowCount = m_RowCount + 1
    > If m_RowCount / 2 = CLng(m_RowCount / 2) Then
    > Me.Detail.BackColor = 12632256 'Set to grey
    > Else
    > Me.Detail.BackColor = 16777215 'This is the white row
    > End If
    > End Sub
    > '===========
    >
    >
    > Can you post the entire Detail_Format sub?
    >
    > SusanV
    >
    > <millie.patel@gmail.com> wrote in message
    > news:1150290816.465402.192370@y41g2000cwy.googlegroups.com...
    > > When I do that, it highlights just the text in the row -- so if text is
    > > longer in one column, it is highlighted more --
    > >
    > > The entire row is not highlighted -- only the text
    > >
    > >
    > > SusanV wrote:
    > >> Regardless of data - rows are rows:
    > >> http://www.codewidgets.com/product.aspx?key=35
    > >> --
    > >> hth,
    > >> SusanV
    > >>
    > >>
    > >> <millie.patel@gmail.com> wrote in message
    > >> news:1150205199.111523.199390@i40g2000cwc.googlegroups.com...
    > >> > Hi All,
    > >> >
    > >> > I have a report that has a subreport with 4 columns (Level 1, 2, 3, 4).
    > >> >
    > >> > I want the report to alternate colors every row; however, each row may
    > >> > have different size values in the columns --
    > >> > for example:
    > >> >
    > >> >
    > >> > Level 1 Level 2 Level 3 Level 4
    > >> > x x x xxx
    > >> > xxx xx xxx
    > >> >
    > >> >
    > >> > that is one row -- i need it to shade the entire row grey -- and the
    > >> > height of the shading to be as long as the Level 4 text.
    > >> >
    > >> >
    > >> > Any ideas/suggestions?
    > >> >
    > >> >
    > >> > Thanks,
    > >> >
    > >> >
    > >> > Millie
    > >> >

    > >
     
  7. millie.patel@gmail.com

    millie.patel@gmail.com
    Expand Collapse
    Guest

    using the code you provided and using this code that i just pasted, i
    get the same results


    millie.patel@gmail.com wrote:
    > Option Compare Database
    > Private shadeNextRow As Boolean
    > Private lastProgression As String
    > Private lastProgressionRow As String
    > Const shadedColor = 16770273
    > Const normalColor = 16777215
    > Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    > If lastProgression <> Me!Progression Or lastProgressionRow <>
    > Me!ProgressionRow Then
    > shadeNextRow = Not shadeNextRow
    > lastProgression = Me!Progression
    > lastProgressionRow = Me!ProgressionRow
    > End If
    > If shadeNextRow Then
    > Me.Section(acDetail).BackColor = shadedColor
    > Else
    > Me.Section(acDetail).BackColor = normalColor
    > End If
    > If Me!CapabilityColor = "red" Then
    > Me!Capability.ForeColor = RGB(255, 0, 0)
    > ElseIf Me!CapabilityColor = "orange" Then
    > Me! Capability.ForeColor = RGB(255, 140, 0)
    > ElseIf Me!CapabilityColor = "green" Then
    > Me! Capability.ForeColor = RGB(0, 100, 0)
    > ElseIf Me!CapabilityColor = "purple" Then
    > Me!Capability.ForeColor = RGB(148, 0, 211)
    > ElseIf Me! CapabilityColor = "blue" Then
    > Me!Capability.ForeColor = RGB(0, 0, 255)
    > End If
    > End Sub
    >
    > SusanV wrote:
    > > Huh? This should set the background color of the row - not any text
    > > formatting such as foreground color or bold or any of that. I use it to
    > > alternate grey and white is several reports as follows:
    > >
    > > '===========
    > > Private m_RowCount As Long
    > > '===========
    > > Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    > > m_RowCount = m_RowCount + 1
    > > If m_RowCount / 2 = CLng(m_RowCount / 2) Then
    > > Me.Detail.BackColor = 12632256 'Set to grey
    > > Else
    > > Me.Detail.BackColor = 16777215 'This is the white row
    > > End If
    > > End Sub
    > > '===========
    > >
    > >
    > > Can you post the entire Detail_Format sub?
    > >
    > > SusanV
    > >
    > > <millie.patel@gmail.com> wrote in message
    > > news:1150290816.465402.192370@y41g2000cwy.googlegroups.com...
    > > > When I do that, it highlights just the text in the row -- so if text is
    > > > longer in one column, it is highlighted more --
    > > >
    > > > The entire row is not highlighted -- only the text
    > > >
    > > >
    > > > SusanV wrote:
    > > >> Regardless of data - rows are rows:
    > > >> http://www.codewidgets.com/product.aspx?key=35
    > > >> --
    > > >> hth,
    > > >> SusanV
    > > >>
    > > >>
    > > >> <millie.patel@gmail.com> wrote in message
    > > >> news:1150205199.111523.199390@i40g2000cwc.googlegroups.com...
    > > >> > Hi All,
    > > >> >
    > > >> > I have a report that has a subreport with 4 columns (Level 1, 2, 3, 4).
    > > >> >
    > > >> > I want the report to alternate colors every row; however, each row may
    > > >> > have different size values in the columns --
    > > >> > for example:
    > > >> >
    > > >> >
    > > >> > Level 1 Level 2 Level 3 Level 4
    > > >> > x x x xxx
    > > >> > xxx xx xxx
    > > >> >
    > > >> >
    > > >> > that is one row -- i need it to shade the entire row grey -- and the
    > > >> > height of the shading to be as long as the Level 4 text.
    > > >> >
    > > >> >
    > > >> > Any ideas/suggestions?
    > > >> >
    > > >> >
    > > >> > Thanks,
    > > >> >
    > > >> >
    > > >> > Millie
    > > >> >
    > > >
     
  8. SusanV

    SusanV
    Expand Collapse
    Guest

    You copied the exact code I posted and you're getting the DATA format
    changing?

    <millie.patel@gmail.com> wrote in message
    news:1150303334.518662.84440@y41g2000cwy.googlegroups.com...
    > using the code you provided and using this code that i just pasted, i
    > get the same results
    >
    >
    > millie.patel@gmail.com wrote:
    >> Option Compare Database
    >> Private shadeNextRow As Boolean
    >> Private lastProgression As String
    >> Private lastProgressionRow As String
    >> Const shadedColor = 16770273
    >> Const normalColor = 16777215
    >> Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    >> If lastProgression <> Me!Progression Or lastProgressionRow <>
    >> Me!ProgressionRow Then
    >> shadeNextRow = Not shadeNextRow
    >> lastProgression = Me!Progression
    >> lastProgressionRow = Me!ProgressionRow
    >> End If
    >> If shadeNextRow Then
    >> Me.Section(acDetail).BackColor = shadedColor
    >> Else
    >> Me.Section(acDetail).BackColor = normalColor
    >> End If
    >> If Me!CapabilityColor = "red" Then
    >> Me!Capability.ForeColor = RGB(255, 0, 0)
    >> ElseIf Me!CapabilityColor = "orange" Then
    >> Me! Capability.ForeColor = RGB(255, 140, 0)
    >> ElseIf Me!CapabilityColor = "green" Then
    >> Me! Capability.ForeColor = RGB(0, 100, 0)
    >> ElseIf Me!CapabilityColor = "purple" Then
    >> Me!Capability.ForeColor = RGB(148, 0, 211)
    >> ElseIf Me! CapabilityColor = "blue" Then
    >> Me!Capability.ForeColor = RGB(0, 0, 255)
    >> End If
    >> End Sub
    >>
    >> SusanV wrote:
    >> > Huh? This should set the background color of the row - not any text
    >> > formatting such as foreground color or bold or any of that. I use it to
    >> > alternate grey and white is several reports as follows:
    >> >
    >> > '===========
    >> > Private m_RowCount As Long
    >> > '===========
    >> > Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    >> > m_RowCount = m_RowCount + 1
    >> > If m_RowCount / 2 = CLng(m_RowCount / 2) Then
    >> > Me.Detail.BackColor = 12632256 'Set to grey
    >> > Else
    >> > Me.Detail.BackColor = 16777215 'This is the white row
    >> > End If
    >> > End Sub
    >> > '===========
    >> >
    >> >
    >> > Can you post the entire Detail_Format sub?
    >> >
    >> > SusanV
    >> >
    >> > <millie.patel@gmail.com> wrote in message
    >> > news:1150290816.465402.192370@y41g2000cwy.googlegroups.com...
    >> > > When I do that, it highlights just the text in the row -- so if text
    >> > > is
    >> > > longer in one column, it is highlighted more --
    >> > >
    >> > > The entire row is not highlighted -- only the text
    >> > >
    >> > >
    >> > > SusanV wrote:
    >> > >> Regardless of data - rows are rows:
    >> > >> http://www.codewidgets.com/product.aspx?key=35
    >> > >> --
    >> > >> hth,
    >> > >> SusanV
    >> > >>
    >> > >>
    >> > >> <millie.patel@gmail.com> wrote in message
    >> > >> news:1150205199.111523.199390@i40g2000cwc.googlegroups.com...
    >> > >> > Hi All,
    >> > >> >
    >> > >> > I have a report that has a subreport with 4 columns (Level 1, 2,
    >> > >> > 3, 4).
    >> > >> >
    >> > >> > I want the report to alternate colors every row; however, each row
    >> > >> > may
    >> > >> > have different size values in the columns --
    >> > >> > for example:
    >> > >> >
    >> > >> >
    >> > >> > Level 1 Level 2 Level 3 Level 4
    >> > >> > x x x xxx
    >> > >> > xxx xx xxx
    >> > >> >
    >> > >> >
    >> > >> > that is one row -- i need it to shade the entire row grey -- and
    >> > >> > the
    >> > >> > height of the shading to be as long as the Level 4 text.
    >> > >> >
    >> > >> >
    >> > >> > Any ideas/suggestions?
    >> > >> >
    >> > >> >
    >> > >> > Thanks,
    >> > >> >
    >> > >> >
    >> > >> > Millie
    >> > >> >
    >> > >

    >
     
  9. millie.patel@gmail.com

    millie.patel@gmail.com
    Expand Collapse
    Guest

    yup

    i still get the data being highlighted - not the entire row

    SusanV wrote:
    > You copied the exact code I posted and you're getting the DATA format
    > changing?
    >
    > <millie.patel@gmail.com> wrote in message
    > news:1150303334.518662.84440@y41g2000cwy.googlegroups.com...
    > > using the code you provided and using this code that i just pasted, i
    > > get the same results
    > >
    > >
    > > millie.patel@gmail.com wrote:
    > >> Option Compare Database
    > >> Private shadeNextRow As Boolean
    > >> Private lastProgression As String
    > >> Private lastProgressionRow As String
    > >> Const shadedColor = 16770273
    > >> Const normalColor = 16777215
    > >> Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    > >> If lastProgression <> Me!Progression Or lastProgressionRow <>
    > >> Me!ProgressionRow Then
    > >> shadeNextRow = Not shadeNextRow
    > >> lastProgression = Me!Progression
    > >> lastProgressionRow = Me!ProgressionRow
    > >> End If
    > >> If shadeNextRow Then
    > >> Me.Section(acDetail).BackColor = shadedColor
    > >> Else
    > >> Me.Section(acDetail).BackColor = normalColor
    > >> End If
    > >> If Me!CapabilityColor = "red" Then
    > >> Me!Capability.ForeColor = RGB(255, 0, 0)
    > >> ElseIf Me!CapabilityColor = "orange" Then
    > >> Me! Capability.ForeColor = RGB(255, 140, 0)
    > >> ElseIf Me!CapabilityColor = "green" Then
    > >> Me! Capability.ForeColor = RGB(0, 100, 0)
    > >> ElseIf Me!CapabilityColor = "purple" Then
    > >> Me!Capability.ForeColor = RGB(148, 0, 211)
    > >> ElseIf Me! CapabilityColor = "blue" Then
    > >> Me!Capability.ForeColor = RGB(0, 0, 255)
    > >> End If
    > >> End Sub
    > >>
    > >> SusanV wrote:
    > >> > Huh? This should set the background color of the row - not any text
    > >> > formatting such as foreground color or bold or any of that. I use it to
    > >> > alternate grey and white is several reports as follows:
    > >> >
    > >> > '===========
    > >> > Private m_RowCount As Long
    > >> > '===========
    > >> > Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    > >> > m_RowCount = m_RowCount + 1
    > >> > If m_RowCount / 2 = CLng(m_RowCount / 2) Then
    > >> > Me.Detail.BackColor = 12632256 'Set to grey
    > >> > Else
    > >> > Me.Detail.BackColor = 16777215 'This is the white row
    > >> > End If
    > >> > End Sub
    > >> > '===========
    > >> >
    > >> >
    > >> > Can you post the entire Detail_Format sub?
    > >> >
    > >> > SusanV
    > >> >
    > >> > <millie.patel@gmail.com> wrote in message
    > >> > news:1150290816.465402.192370@y41g2000cwy.googlegroups.com...
    > >> > > When I do that, it highlights just the text in the row -- so if text
    > >> > > is
    > >> > > longer in one column, it is highlighted more --
    > >> > >
    > >> > > The entire row is not highlighted -- only the text
    > >> > >
    > >> > >
    > >> > > SusanV wrote:
    > >> > >> Regardless of data - rows are rows:
    > >> > >> http://www.codewidgets.com/product.aspx?key=35
    > >> > >> --
    > >> > >> hth,
    > >> > >> SusanV
    > >> > >>
    > >> > >>
    > >> > >> <millie.patel@gmail.com> wrote in message
    > >> > >> news:1150205199.111523.199390@i40g2000cwc.googlegroups.com...
    > >> > >> > Hi All,
    > >> > >> >
    > >> > >> > I have a report that has a subreport with 4 columns (Level 1, 2,
    > >> > >> > 3, 4).
    > >> > >> >
    > >> > >> > I want the report to alternate colors every row; however, each row
    > >> > >> > may
    > >> > >> > have different size values in the columns --
    > >> > >> > for example:
    > >> > >> >
    > >> > >> >
    > >> > >> > Level 1 Level 2 Level 3 Level 4
    > >> > >> > x x x xxx
    > >> > >> > xxx xx xxx
    > >> > >> >
    > >> > >> >
    > >> > >> > that is one row -- i need it to shade the entire row grey -- and
    > >> > >> > the
    > >> > >> > height of the shading to be as long as the Level 4 text.
    > >> > >> >
    > >> > >> >
    > >> > >> > Any ideas/suggestions?
    > >> > >> >
    > >> > >> >
    > >> > >> > Thanks,
    > >> > >> >
    > >> > >> >
    > >> > >> > Millie
    > >> > >> >
    > >> > >

    > >
     
  10. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    millie.patel@gmail.com wrote:
    > yup
    >
    > i still get the data being highlighted - not the entire row


    When you state that you have "multiple columns of data" do you mean multiple
    fields arranged in columns or do you mean that you are using the
    Multi-column options in Page Setup of the report?

    Using the "newspaper columns" option in page setup will produce a different
    effect because the detail section is not only repeated in horizontal bands
    but also snaked into columns and the background WILL have some margin
    separation between those columns.


    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     
  11. millie.patel@gmail.com

    millie.patel@gmail.com
    Expand Collapse
    Guest

    The subreport is broken up into 4 columns via the Page Setup of the
    report....

    So is there any way of getting around this issue?



    Rick Brandt wrote:
    > millie.patel@gmail.com wrote:
    > > yup
    > >
    > > i still get the data being highlighted - not the entire row

    >
    > When you state that you have "multiple columns of data" do you mean multiple
    > fields arranged in columns or do you mean that you are using the
    > Multi-column options in Page Setup of the report?
    >
    > Using the "newspaper columns" option in page setup will produce a different
    > effect because the detail section is not only repeated in horizontal bands
    > but also snaked into columns and the background WILL have some margin
    > separation between those columns.
    >
    >
    > --
    > Rick Brandt, Microsoft Access MVP
    > Email (as appropriate) to...
    > RBrandt at Hunter dot com
     
  12. millie.patel@gmail.com

    millie.patel@gmail.com
    Expand Collapse
    Guest

    The subreport is broken up into 4 columns via the Page Setup of the
    report....

    So is there any way of getting around this issue?



    Rick Brandt wrote:
    > millie.patel@gmail.com wrote:
    > > yup
    > >
    > > i still get the data being highlighted - not the entire row

    >
    > When you state that you have "multiple columns of data" do you mean multiple
    > fields arranged in columns or do you mean that you are using the
    > Multi-column options in Page Setup of the report?
    >
    > Using the "newspaper columns" option in page setup will produce a different
    > effect because the detail section is not only repeated in horizontal bands
    > but also snaked into columns and the background WILL have some margin
    > separation between those columns.
    >
    >
    > --
    > Rick Brandt, Microsoft Access MVP
    > Email (as appropriate) to...
    > RBrandt at Hunter dot com
     
  13. millie.patel@gmail.com

    millie.patel@gmail.com
    Expand Collapse
    Guest

    The subreport is broken up into 4 columns via the Page Setup of the
    report....

    So is there any way of getting around this issue?



    Rick Brandt wrote:
    > millie.patel@gmail.com wrote:
    > > yup
    > >
    > > i still get the data being highlighted - not the entire row

    >
    > When you state that you have "multiple columns of data" do you mean multiple
    > fields arranged in columns or do you mean that you are using the
    > Multi-column options in Page Setup of the report?
    >
    > Using the "newspaper columns" option in page setup will produce a different
    > effect because the detail section is not only repeated in horizontal bands
    > but also snaked into columns and the background WILL have some margin
    > separation between those columns.
    >
    >
    > --
    > Rick Brandt, Microsoft Access MVP
    > Email (as appropriate) to...
    > RBrandt at Hunter dot com
     
  14. SusanV

    SusanV
    Expand Collapse
    Guest

    Hi millie,
    I honestly don't know... Sorry =(

    SusanV
    <millie.patel@gmail.com> wrote in message
    news:1150379776.960276.244740@c74g2000cwc.googlegroups.com...
    > The subreport is broken up into 4 columns via the Page Setup of the
    > report....
    >
    > So is there any way of getting around this issue?
    >
    >
    >
    > Rick Brandt wrote:
    >> millie.patel@gmail.com wrote:
    >> > yup
    >> >
    >> > i still get the data being highlighted - not the entire row

    >>
    >> When you state that you have "multiple columns of data" do you mean
    >> multiple
    >> fields arranged in columns or do you mean that you are using the
    >> Multi-column options in Page Setup of the report?
    >>
    >> Using the "newspaper columns" option in page setup will produce a
    >> different
    >> effect because the detail section is not only repeated in horizontal
    >> bands
    >> but also snaked into columns and the background WILL have some margin
    >> separation between those columns.
    >>
    >>
    >> --
    >> Rick Brandt, Microsoft Access MVP
    >> Email (as appropriate) to...
    >> RBrandt at Hunter dot com

    >
     
  15. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    millie.patel@gmail.com wrote:
    > The subreport is broken up into 4 columns via the Page Setup of the
    > report....
    >
    > So is there any way of getting around this issue?


    You can set the spacing between the columns to zero and make the physical
    column a bit wider to provide the same spacing, but the first row at the top
    of each column will not be the same actual "row" that is at the top of any
    of the other columns.

    In order to to get the same odd/even color you will have to configure your
    page setup so that each column ends on an even numbered row so that the
    first row at the top of the next column will always be an odd numbered row.
    If you have no controls in the report that Grow or Shrink then this should
    be possible to do. If you do have anything that grows/shrinks then you're
    SOL.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     
  16. millie.patel@gmail.com

    millie.patel@gmail.com
    Expand Collapse
    Guest

    i think im SOL :(

    thanks all for your help anyway!


    Rick Brandt wrote:
    > millie.patel@gmail.com wrote:
    > > The subreport is broken up into 4 columns via the Page Setup of the
    > > report....
    > >
    > > So is there any way of getting around this issue?

    >
    > You can set the spacing between the columns to zero and make the physical
    > column a bit wider to provide the same spacing, but the first row at the top
    > of each column will not be the same actual "row" that is at the top of any
    > of the other columns.
    >
    > In order to to get the same odd/even color you will have to configure your
    > page setup so that each column ends on an even numbered row so that the
    > first row at the top of the next column will always be an odd numbered row.
    > If you have no controls in the report that Grow or Shrink then this should
    > be possible to do. If you do have anything that grows/shrinks then you're
    > SOL.
    >
    > --
    > Rick Brandt, Microsoft Access MVP
    > Email (as appropriate) to...
    > RBrandt at Hunter dot com
     

Share This Page