Columns setting in report

[deepaksharma]

Increase the line spacing property to be larger than 0"

Line space property not found anywhere in menu bar would this be possible by coding.
Thank you.

[Micron]

Can you hear me sighing from here?


Getting tired of you not feeding yourself. All you had to do was Google 'ms access line spacing' and you would have found it yourself. But no...

[deepaksharma]

had to do was Google 'ms access line spacing' and you would have found it yourself. But no...

That's not the case. I've been googling it ever since I posted this query. How can I make the text box white and increase the line space in these text box? Whenever I google, I get told about coding. I used to search for it a lot in the design tools of Ribbon but even there I could not find it. I did not know that the problem which I was considering as big as an elephant, would actually turn out to be as small as an ant. Please don't feel bad.
Thank you.

[deepaksharma]

I want to tell you all that I am from India and tomorrow we have the festival of Diwali which is the biggest festival of our country. I want to wish Happy Diwali to all you members of this forum. Best wishes to all of you on Diwali.
Jai Shri Ram.
thank you......

[Welshgasman]

That's not the case. I've been googling it ever since I posted this query. How can I make the text box white and increase the line space in these text box? Whenever I google, I get told about coding. I used to search for it a lot in the design tools of Ribbon but even there I could not find it. I did not know that the problem which I was considering as big as an elephant, would actually turn out to be as small as an ant. Please don't feel bad.
Thank you.

https://www.google.com/search?q=ms+a...hrome&ie=UTF-8

[Micron]

I'm not talking about general stuff like this

How can I make the text box white and increase the line space in these text box?

I'm talking about when anyone is told what to do, or given a term or maybe a property name that they don't know about or understand, you and a whole lot of other people write back and ask "how do you do that?" or "I don't know what that is." or whatever. Then research the answer given for Heaven's sake. Key word in the suggestion - "property". You look in the property sheet for properties, not the ribbon and you should know that by now.

Enjoy your festival!

[deepaksharma]

DoCmd.OpenReport "Grey_Offer", acPreview, , "OfferID BETWEEN " & Me.cbxStart & " AND " & Me.cbxEnd

If here you want to set offer date instead of offer ID, then what change has to be made in this code i have made this change but it is not working.

 DoCmd.OpenReport "Grey_Offer", acPreview, , "Offerdate BETWEEN " & Me.cbxStart & " AND " & Me.cbxEnd

[June7]

Need # delimiters for date/time parameters.

"Offerdate BETWEEN #" & Me.cbxStart & "# AND #" & Me.cbxEnd & "#"

[Minty]

You need to put date delimiters around your combo box values, and possibly format them to the correct layout, depending on your regional settings.

  Dim strWhere as string

  strWhere = "Offerdate BETWEEN #" & Me.cbxStart & "# AND #" & Me.cbxEnd & "#"
  Debug.print strWhere

   DoCmd.OpenReport "Grey_Offer", acPreview, , strWhere

[Welshgasman]

Need # delimiters for date/time parameters.

"Offerdate BETWEEN #" & Me.cbxStart & "# AND #" & Me.cbxEnd & "#"

Also your dates need to be in mm/dd/yyyy or yyyy-mm-dd format.

[deepaksharma]

Thanks it's working...........