Feb 4, 2003 #1 ffleitas Technical User Mar 15, 2001 85 US Hello programmers, How to I display on a report a data date field as 020403 instead of 02/04/03? Thanks, Felix
Hello programmers, How to I display on a report a data date field as 020403 instead of 02/04/03? Thanks, Felix
Feb 4, 2003 1 #2 PaulBricker Programmer Sep 25, 2002 3,554 US Try this in the control source for you textbox. =Format(DateField,"mmddyy" Paul Upvote 0 Downvote
Feb 5, 2003 1 #3 VicM Programmer Sep 24, 2001 444 US ffleitas: If Paul's suggestion doesn't work for you (I had trouble using the Format function in the Control Source Property), then try putting mmddyy in the Format Property of the Format tab of your textbox control. That worked for me. Hope this helps, Vic Upvote 0 Downvote
ffleitas: If Paul's suggestion doesn't work for you (I had trouble using the Format function in the Control Source Property), then try putting mmddyy in the Format Property of the Format tab of your textbox control. That worked for me. Hope this helps, Vic