Member Login:
e-mail:
password:
Register
Forgot Password
Site FAQ
Home
>
IT Answers
>
Database
> Format a field
Sue77
5 pts.
Format a field
Access Database
,
Microsoft Access
I need to format a text box to begin with a zero with no decimals (i.e. 0310) If I type in 0310, it appears as 310.
Software/Hardware used:
ASKED:
March 16, 2009 12:20 PM
UPDATED:
March 16, 2009 12:48 PM
Discuss
 
Add to Watchlist
RELATED QUESTIONS
How do I convert a date in text format to a proper date with AS/400 Query
How to change MSV file to a format for mac
Hard drive format
export sql server 2005 to dbf
As400 files - a basic question from a newbie
Answer Wiki:
Set the field type as text and in any formula you may convert it to number
Set the field type as text and in any formula you may convert it to number
Last Wiki Answer Submitted:
March 16, 2009 12:37 pm
by
Sous
580 pts.
All Answer Wiki Contributors:
Sous
580 pts.
To see all answers submitted to the Answer Wiki:
View Answer History
.
Please complete the following information:
REGISTER / LOG-IN TO ANSWER QUESTION
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Submit your e-mail address below to continue
E-mail: 
E-mail:
Company:
Handle:
Password:
Forgot Password?
Create Handle:
Your handle identifies you in IT Answers. Max 30 char.
Create Password:
Confirm Password:
Yes, I'd like to receive the IT Knowledge Exchange Community Newsletter
Yes, I agree to the
Terms and Conditions.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.
hidden modal window
RSS - Discussions
Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Please complete the following information:
REGISTER / LOG-IN TO DISCUSS
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Submit your e-mail address below to continue
E-mail: 
E-mail:
Company:
Handle:
Password:
Forgot Password?
Create Handle:
Your handle identifies you in IT Answers. Max 30 char.
Create Password:
Confirm Password:
Yes, I'd like to receive the IT Knowledge Exchange Community Newsletter
Yes, I agree to the
Terms and Conditions.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.
hidden modal window
Ask a Question
Question Title:
(150 char. limit.)
Question:
(Please be specific.)
Tags:
(Separate each tag with a comma.)
What is a Tag?
Browse IT Answers by Topic
AS/400
Big Data
Business Intelligence
Channel
CIO
Cloud Computing
Consumerization
CRM
Database
DataCenter
Development
Exchange
Linux
Lotus Domino
Microsoft Windows
Mobile
Networking
Oracle
SAP
Security
SQL Server
Storage
Virtualization
VoIP
Windows Server
>>
VIEW ALL TAGS