MS Access Expert Advice Needed

  fitshase 11:19 08 May 06
Locked

I am creating a database in MS Access and would appreciate some help on the following things:-

(1) In the table design view, I have some 40 fields set up so far. However, I have an input mask set up on most of them in a date format. If I change one of these, is there a way to replicate the settings to the other ones (without having to click on each one and manually change the input mask field)?


(2) In the table view, the headings are quite long in length (as the field names are long). I would like them visible but is there a way of wrapping the text in the table view so the header row is larger making the columns thinner (much like you can do in Excel)?

Any help is appreciated.

Cheers

Fitshase

  Taff™ 12:54 08 May 06

I don`t know if this will work but it does in Word & Excel. Format the first one. Select the next one and press the CTRL Key + Y Key at the same time. This repeats the last action. Try it and see if it works.

  fitshase 13:04 08 May 06

Cheers for that but it doesn't work I'm afraid.

Fitshase

  Woolwell 15:01 08 May 06

In table design view go to the left hand column and move your mouse pointer to the line below the long heading and drag the line down and the text should now wrap.

  fitshase 15:08 08 May 06

Thanks but that only works in the table design view. I need it to work in the table view (i.e., where you input the information).

Cheers

Fitshase

  Woolwell 15:19 08 May 06

I normally use a form to enter data into a table. By using a form you can wrap text and put your text where you want and you can put more explanatory text. I think that to do what you want you will have to go down this route. The form wizard will design some reasonable forms but I usually want more control and go into design.

I do not know of a way to copy input masks. As I understand it each input mask is specific to a field. I stand to be corrected by others who know more about Access than I do.

  Access genu 23:12 08 May 06

I would think that the only way of doing 1 is to write some code to alter that particular poperty of all the fields.

2. there is no way to do this. data entry into a data base should be via a form and not directly into the tables.

This thread is now locked and can not be replied to.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…