Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Special Time fields question 1

Status
Not open for further replies.

kco1122

Programmer
Nov 16, 2000
3
US
I have a question about the special time control in the rdc for vb. I put in a time control and then linked it to a field in a recordset. Now the information in the recordset is just a time field, hh:mm am/pm.

However everytime I run the report, I get the date as well as time. Now I've also taken a look at the formula for this control and it's "time(0,0,0)" so shouldn't that override whatever it's getting from the recordset and pushing it into this format?

Is there anyway I can force the time control to NOT display the date? Or do I need to fiddle with my data and see if the cause is located there?
 
Don't work with the RDC, but can't you just format the result in the report so that it shows only the time value? Malcolm
wynden@telus.net
November is "be kind to dogs and programmers" month. Or is that "dogs or programmers"?
 
Is this "special time control" an unbound field? If not where did you get it?

If it is an unbound field, are you linking it to a field that has date and time?

Have you tried right-clicking the object and using the "Format" option to determine the format. Ken Hamady
Crystal Reports Training and a
Quick Reference Guide to VB/Crystal
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top