help?!! How do you format a cell in access?

[JINOCUTE]

I've got a big problem!!!

I need to format numbers in the table/cell itself

For example I entered 1024 in the View Page in Access on a Table and when I move out of that cell the 1024 would automatically be 10.24.

ex: 12345 would be 123.45 and 45 would be .45

the problem is how do I do it in the table itself without using queries, forms, etc. just the plain table (like excel)

and in MS access....

 

[orna]

Hi

In the Input Mask of the field insert 99.99 and the Data Type can be Single.

 

[danvlas]

I don't think you can...but I stand corrected if I'm wrong.

Tables in Access are places to store data and have only limited programming features.

After an application is finalized, tables are usually hidden from users.
It is always a bad idea to enter data directly in the tables.

But you can simulate it throug a form.

Create a form - use a wizard - based on your table.
Use the AfterUpdate event of the textbox bound to that field to divide it by 100 after something is entered there.

Private Sub CtrName_AfterUpdate()
CtrName = CtrName/100
End Sub

Then set the default view of the form to Datasheet and open it.
It will look like the table, but will behave like a form.

HTH




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html