What is the size limit per a record/field?

What is the size limit for text fields?

Sometimes text data can be extremely lengthy.

As well, it should not happen if the tables are normalized, but how many fields can a table have?