Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > Forums > Access
Back to Access Forum    Comments List
Date Format Upload Images   Link   Email  
Mohammed Aslam Khan     
2 months ago
Hi, i have 2 date fields in my database. both are formatted as dd-mmm-yy. But only the first date shows in the correct format while the second date is in m/d/yy format.
Sami Shamma               
2 months ago
Mohammed
The question is vague. Are these fields on the table? Are they in a form?
Mohammed Aslam Khan     
2 months ago
Hi Sami, yes i have 2 date fields in my table (DateStart and DateEnd). I created a form relating to this table. In the table, i have formatted both the fields as Date/Time and as dd-mmm-yy. On the form, when i enter data, the DateStart is exactly as i have formatted, but the DateEnd is not according to the format, it shows as m/d/yy.
Mohammed Aslam Khan     
2 months ago

Sami Shamma               
2 months ago
Show me the format tab for the second date field on your form design view
Mohammed Aslam Khan     
2 months ago
attaching below the 2 date field settings in the table
Mohammed Aslam Khan     
2 months ago

Mohammed Aslam Khan     
2 months ago

Sami Shamma               
2 months ago
Not the table format. The Form format for the dates on the form.
Mohammed Aslam Khan     
2 months ago

Mohammed Aslam Khan     
2 months ago
I did not perform any changes in the Form Design Properties
Sami Shamma               
2 months ago
Mohammed. This is the Data tab. I want to see the Format tab.
Mohammed Aslam Khan     
2 months ago
Hi Sami, I am very new and not very tech savvy. I don't understand what is the Format tab. Is the Format ribbon you want to see.
Mohammed Aslam Khan     
2 months ago

Mohammed Aslam Khan     
2 months ago
is the above image correct ?
Sami Shamma               
2 months ago
On the property sheet you have show in the image.
There is
Format'Data'Events'Others'All.
Click on format.
Sami Shamma               
2 months ago
No
Mohammed Aslam Khan     
2 months ago

Mohammed Aslam Khan     
2 months ago
Is it correct now ?
Sami Shamma               
2 months ago
Yes. This is the correct image.
Do you see the problem?
Look at the Format property of both, you will see the problem.


DateEnd is missing the format.
Mohammed Aslam Khan     
2 months ago
Oh yes :)

Thank you very much.

But I still wonder why is it that it accepted DateStart and did not accept DateEnd. I did not use this Format Tab at all. All I did was in the Table Properties which shows down when you enter the fields.

However, Thank you again. I guess I will learn learn more of technical aspects here :)
Sami Shamma               
2 months ago
You're welcome my brother.
It depends on how you selected the fields to go on your form.
Richard Rost             
2 months ago
The form will always inherit the formatting properties for fields at the moment that you create them, but if you go back and change the format in the table, the format will not carry through to the form unless you manually change it.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/21/2024 8:28:26 PM. PLT: 0s