Solved

Visual Data Manager (Date/Time format)

Posted on 1998-12-01
7
209 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
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 

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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
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…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
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…

757 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now