Solved

Visual Data Manager (Date/Time format)

Posted on 1998-12-01
7
212 Views
Last Modified: 2008-10-12
Using VB 5.0
I am using the Visual Data Manger to create a database and am declaring a field with date/time format.  My problem is when I go to add records to the database, it only allows me 5 spaces for the date entry (I need at least 6 spaces mmddyy).  I am not sure how to increase this field limit?
0
Comment
Question by:DonKMoore
  • 4
  • 3
7 Comments
 

Author Comment

by:DonKMoore
ID: 1447622
Edited text of question
0
 
LVL 2

Expert Comment

by:Bhargava
ID: 1447623
If the field type is date/time the size of the field will be defaulted to 8 and cannot be changed.
0
 

Author Comment

by:DonKMoore
ID: 1447624
The field size shows 8 when building the database, but when I go to enter the data it only allows 5 characters.
0
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 

Author Comment

by:DonKMoore
ID: 1447625
The field size shows 8 when building the database, but when I go to enter the data it only allows 5 characters.
0
 
LVL 2

Expert Comment

by:Bhargava
ID: 1447626
whih database are you using
0
 

Author Comment

by:DonKMoore
ID: 1447627
I am using Access 7.0
0
 
LVL 2

Accepted Solution

by:
Bhargava earned 100 total points
ID: 1447628
I dont see a chance that it will only take 5 characters. Let me ask you one thing! are you using a filed on a form with some kind of validation or some restriction on the field to take only a legth of 5 chars. you might have specified MaxLength to 5 or some kind of validation. Please check
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question