Page 1 of 4 123 ... LastLast
Results 1 to 15 of 48
  1. #1
    2 Star Lounger
    Join Date
    Apr 2008
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm using Office 2002 and I am trying to combine a date field with text on a report.

    I want the text field on the report to read something like this:

    On Saturday, January 2, 2010, we had a snowstorm.

    Code I was using is ="On "& [Date] &", we had a snowstorm."

    I can combine the date field into the text field but I can not get the date to appear in Long Date format. It comes up 01/02/2010. I have tried changing format settings on both the date field and on the text field and in the table that the date comes from. No luck.

    Any suggestions?

    Thanks.

    Paul

  2. #2
    2 Star Lounger
    Join Date
    Apr 2008
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm using Office 2002 and I am trying to combine a date field with text on a report.

    I want the text field on the report to read something like this:

    On Saturday, January 2, 2010, we had a snowstorm.

    Code I was using is ="On "& [Date] &", we had a snowstorm."

    I can combine the date field into the text field but I can not get the date to appear in Long Date format. It comes up 01/02/2010. I have tried changing format settings on both the date field and on the text field and in the table that the date comes from. No luck.

    Any suggestions?

    Thanks.

    Paul

  3. #3
    2 Star Lounger
    Join Date
    Apr 2008
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm using Office 2002 and I am trying to combine a date field with text on a report.

    I want the text field on the report to read something like this:

    On Saturday, January 2, 2010, we had a snowstorm.

    Code I was using is ="On "& [Date] &", we had a snowstorm."

    I can combine the date field into the text field but I can not get the date to appear in Long Date format. It comes up 01/02/2010. I have tried changing format settings on both the date field and on the text field and in the table that the date comes from. No luck.

    Any suggestions?

    Thanks.

    Paul

  4. #4
    2 Star Lounger
    Join Date
    Apr 2008
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm using Office 2002 and I am trying to combine a date field with text on a report.

    I want the text field on the report to read something like this:

    On Saturday, January 2, 2010, we had a snowstorm.

    Code I was using is ="On "& [Date] &", we had a snowstorm."

    I can combine the date field into the text field but I can not get the date to appear in Long Date format. It comes up 01/02/2010. I have tried changing format settings on both the date field and on the text field and in the table that the date comes from. No luck.

    Any suggestions?

    Thanks.

    Paul

  5. #5
    2 Star Lounger
    Join Date
    Apr 2008
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm using Office 2002 and I am trying to combine a date field with text on a report.

    I want the text field on the report to read something like this:

    On Saturday, January 2, 2010, we had a snowstorm.

    Code I was using is ="On "& [Date] &", we had a snowstorm."

    I can combine the date field into the text field but I can not get the date to appear in Long Date format. It comes up 01/02/2010. I have tried changing format settings on both the date field and on the text field and in the table that the date comes from. No luck.

    Any suggestions?

    Thanks.

    Paul

  6. #6
    2 Star Lounger
    Join Date
    Apr 2008
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm using Office 2002 and I am trying to combine a date field with text on a report.

    I want the text field on the report to read something like this:

    On Saturday, January 2, 2010, we had a snowstorm.

    Code I was using is ="On "& [Date] &", we had a snowstorm."

    I can combine the date field into the text field but I can not get the date to appear in Long Date format. It comes up 01/02/2010. I have tried changing format settings on both the date field and on the text field and in the table that the date comes from. No luck.

    Any suggestions?

    Thanks.

    Paul

  7. #7
    2 Star Lounger
    Join Date
    Apr 2008
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm using Office 2002 and I am trying to combine a date field with text on a report.

    I want the text field on the report to read something like this:

    On Saturday, January 2, 2010, we had a snowstorm.

    Code I was using is ="On "& [Date] &", we had a snowstorm."

    I can combine the date field into the text field but I can not get the date to appear in Long Date format. It comes up 01/02/2010. I have tried changing format settings on both the date field and on the text field and in the table that the date comes from. No luck.

    Any suggestions?

    Thanks.

    Paul

  8. #8
    2 Star Lounger
    Join Date
    Apr 2008
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm using Office 2002 and I am trying to combine a date field with text on a report.

    I want the text field on the report to read something like this:

    On Saturday, January 2, 2010, we had a snowstorm.

    Code I was using is ="On "& [Date] &", we had a snowstorm."

    I can combine the date field into the text field but I can not get the date to appear in Long Date format. It comes up 01/02/2010. I have tried changing format settings on both the date field and on the text field and in the table that the date comes from. No luck.

    Any suggestions?

    Thanks.

    Paul

  9. #9
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Code I was using is ="On "& [Date] &", we had a snowstorm."
    Change the control source for this textbox to:

    ="On "& Format([Date], "Long Date") &", we had a snowstorm."

    Note that Date is a reserved word in Access and not the best choice of name for a date field. Also, how Long Date displays is entirely dependent on the settings for Long Date in Regional Settings in Control Panels. You could also specify exact formatting rather than Long Date, e.g. "mmm d, yyyy" which would give you January 2, 2010 or "dddd, mmm d yyyy" which will give you Saturday, January 2, 2010 as you indicate.

  10. #10
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Code I was using is ="On "& [Date] &", we had a snowstorm."
    Change the control source for this textbox to:

    ="On "& Format([Date], "Long Date") &", we had a snowstorm."

    Note that Date is a reserved word in Access and not the best choice of name for a date field. Also, how Long Date displays is entirely dependent on the settings for Long Date in Regional Settings in Control Panels. You could also specify exact formatting rather than Long Date, e.g. "mmm d, yyyy" which would give you January 2, 2010 or "dddd, mmm d yyyy" which will give you Saturday, January 2, 2010 as you indicate.

  11. #11
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Code I was using is ="On "& [Date] &", we had a snowstorm."
    Change the control source for this textbox to:

    ="On "& Format([Date], "Long Date") &", we had a snowstorm."

    Note that Date is a reserved word in Access and not the best choice of name for a date field. Also, how Long Date displays is entirely dependent on the settings for Long Date in Regional Settings in Control Panels. You could also specify exact formatting rather than Long Date, e.g. "mmm d, yyyy" which would give you January 2, 2010 or "dddd, mmm d yyyy" which will give you Saturday, January 2, 2010 as you indicate.

  12. #12
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Code I was using is ="On "& [Date] &", we had a snowstorm."
    Change the control source for this textbox to:

    ="On "& Format([Date], "Long Date") &", we had a snowstorm."

    Note that Date is a reserved word in Access and not the best choice of name for a date field. Also, how Long Date displays is entirely dependent on the settings for Long Date in Regional Settings in Control Panels. You could also specify exact formatting rather than Long Date, e.g. "mmm d, yyyy" which would give you January 2, 2010 or "dddd, mmm d yyyy" which will give you Saturday, January 2, 2010 as you indicate.

  13. #13
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Code I was using is ="On "& [Date] &", we had a snowstorm."
    Change the control source for this textbox to:

    ="On "& Format([Date], "Long Date") &", we had a snowstorm."

    Note that Date is a reserved word in Access and not the best choice of name for a date field. Also, how Long Date displays is entirely dependent on the settings for Long Date in Regional Settings in Control Panels. You could also specify exact formatting rather than Long Date, e.g. "mmm d, yyyy" which would give you January 2, 2010 or "dddd, mmm d yyyy" which will give you Saturday, January 2, 2010 as you indicate.

  14. #14
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Code I was using is ="On "& [Date] &", we had a snowstorm."
    Change the control source for this textbox to:

    ="On "& Format([Date], "Long Date") &", we had a snowstorm."

    Note that Date is a reserved word in Access and not the best choice of name for a date field. Also, how Long Date displays is entirely dependent on the settings for Long Date in Regional Settings in Control Panels. You could also specify exact formatting rather than Long Date, e.g. "mmm d, yyyy" which would give you January 2, 2010 or "dddd, mmm d yyyy" which will give you Saturday, January 2, 2010 as you indicate.

  15. #15
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Code I was using is ="On "& [Date] &", we had a snowstorm."
    Change the control source for this textbox to:

    ="On "& Format([Date], "Long Date") &", we had a snowstorm."

    Note that Date is a reserved word in Access and not the best choice of name for a date field. Also, how Long Date displays is entirely dependent on the settings for Long Date in Regional Settings in Control Panels. You could also specify exact formatting rather than Long Date, e.g. "mmm d, yyyy" which would give you January 2, 2010 or "dddd, mmm d yyyy" which will give you Saturday, January 2, 2010 as you indicate.

Page 1 of 4 123 ... LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •