formatting reports

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Formatting reports

Formatting reports

resolvedResolved · High Priority · Version 2003

Sarah has attended:
Access Introduction course

Formatting reports

In access reports, how do I wrap the text to ensure i see all the contents. Also, does access allow predictive text, so if you type a word that has already been entred, the system would predict the word and spell it for you.

RE: Formatting reports

Hi sarah

Thank you for your question

If you set the "can grow" and "can shrink" properties of the text boxes and the detail section of the report to yes, the height of the text box will grow with the data, effectivelly wrapping the text.

As to predictive text, the only thing I can suggest is that you use combo boxes. When you type in a combo box, the text will be completed to match any items in the field.

Regards

Stephen


 

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips


Server loaded in 0.1 secs.