Access

The UK's most regular instructor-led training courses.
Training information: microsoft access training class · Courses in microsoft access · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version 2003

Access

Simon has attended:
Access Intermediate course
Access Advanced course

by - delegate Simon [1 post] (2008 May 16 Fri, 16:23) Reply

how many non-data fields can we use within a table? i.e. word limit to text box.

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Sep 4 Thu + 5 Fri	Southwark	3	book now	£475	£495
2003/XP	2008 Oct 20 Mon + 21 Tue	Southwark	6	book now	£450	£485
2003/XP	2008 Nov 6 Thu + 7 Fri	Southwark	8	book now	£275	£399
2003/XP	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003/XP	2009 Jan 8 Thu + 9 Fri	Southwark	7	book now	£345	£399
2003/XP	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 15 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Access

by - trainer Richard platinum contributer [779 posts] (2008 May 19 Mon, 15:23) Reply

Hello Simon,

Hope you enjoyed your Microsoft Access courses with BEST STL Training.

Thank you for your question regarding data fields.

You can have upto 255 fields of data in a table.

Within each field you can customise the properties.
A standard text field can only contain upto 255 characters. A memo field can contain upto 16000 or so characters.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post.
Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer