[Access2000_Form]Date Format for Textbox which is linked with table text field. (1 Viewer)

hmmh

New member
Local time
Today, 18:06
Joined
Dec 18, 2015
Messages
2
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.
 

Users who are viewing this thread

Top Bottom