Is it possible to format cell automatically in MS Access?

Asked By beverly 0 points N/A Posted on - 11/02/2011

I want to import an Excel file with client information into an MS Access database, but some data were not entered properly as some are in caps or it does start with a capital letter.  Is it possible to format cells automatically in such a way that “LONDON”, for example, becomes “London”?

• Status: Open
• Question Views: 737
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by Baker Alex

Go To Solution

Answered By Zorian Crust 80 points N/A #100490

Is it possible to format cell automatically in MS Access?

Hello Beverly,

You can use Mask Wizard in MS Access for a lot of formatting features that you want. I suggest you to download the Mask Wizard and follow the instructions:

You can also try the following steps:

• Choose a design view in the view menu.
• In the data type column from the drop down menu, click TEXT.
• Choose the general tab at the bottom half of the screen.
• Click the input mask field at the far right.
• Save the sheet.
• Choose the text or the words  you want to copy and then hit finish.

 

-Zorian

About Zorian Crust

Questions
0

Answers
377

Best Answers
138

• Vote Up 0 Vote Down

• Posted on - 11/02/2011
• Question Category: MS Access

Best Answer

Best Answer

Answered By Baker Alex 0 points N/A #100491

Is it possible to format cell automatically in MS Access?

Yes, there is a solution for import Excel file into an MS Access database. For solving this problem you need to use the Mask Wizard for importing Excel file into the MS Access database.

After installing this, please follow these instructions step by step:

1. Choose design view from view menu.

2. Right-click the field you want to modify.

3. Click on Properties from the pop-up menu.

4. Click on the Data tab.

5. Now click on the Input Mask text box and then select a mask to continue.

6. You may make modifications if necessary. Then click next to save the sheet.

Thanks

About Baker Alex

Questions
1

Answers
24

Best Answers
6

• Vote Up 0 Vote Down

• Posted on - 12/08/2012
• Question Category: MS Access