Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-17-2015, 08:05 PM   #1
hmmh
Newly Registered User
 
Join Date: Dec 2015
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
hmmh is on a distinguished road
[Access2000_Form]Date Format for Textbox which is linked with table text field.

Hello everyone,
Please help me with the following question.

Date Format for Textbox which is linked with a text field in a table.

I tested with following procedure.

#.Change the format setting for the textbox on the form as currency.
(there is no option in the format(drop down menu) but I typed "currency" and
its automatically change the japanese words <coz I'm in jp environment> )

The upper procedure is only work for
if the textbox is linked with number field in the table.
BUT IT WON'T WORK FOR IF THE TEXTBOX IS LINKED WITH TEXT FIELD IN THE TABLE.

The question is
1.How can I show in the textbox as currency format which is like ( 12,345,678).Its also restricted as 8digit and no need to currency sign.

2.If I can show,when the data is insert in the table It also has to be inserted
as 8digit number only.

Condition for me is that I can't easily change the restriction.

hmmh is offline   Reply With Quote
Old 12-18-2015, 06:43 AM   #2
llkhoutx
Newly Registered User
 
Join Date: Feb 2001
Location: Houston,Texas USA
Posts: 4,018
Thanks: 6
Thanked 106 Times in 104 Posts
llkhoutx is on a distinguished road
Re: [Access2000_Form]Date Format for Textbox which is linked with table text field.

Use the Format property of the textbox.
__________________
Get the job done right, rather than do the right job.
Do it fast or do it right. Teach a man a fish . . .
If it ain't broke, don't fix it.
Note that I don't open posted databases, period.
llkhoutx is offline   Reply With Quote
Reply

Tags
date format , form , textbox

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Linked Table Date is Text kujospam Queries 10 07-23-2013 03:06 AM
Count Date from Text format field kabilliu Queries 7 11-03-2012 05:38 AM
Create a field in DATE format based on a field in TEXT accessfever Queries 2 03-27-2011 07:25 AM
Text field Format as Date not working Garindan Tables 7 02-22-2011 04:36 AM
Format Text field data as Date razorking Queries 1 10-06-2006 09:32 AM




All times are GMT -8. The time now is 02:03 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World