Access 2010 query truncates memo field -

The following query access to use the report to select data to me I it works except that he What_is_hidden field is smaller.

SQL what database strike the field as a Nrwcr (maximum) - Access 2010, it has been viewed as a memo field.

me.

.full_name, dbo_event_log_shack.actual_date, dbo_e_l_v_al_id_is_active_client, [dbo_all_clients_view query] .policy_num, dbo_event_log_shack.event_log_id, dbo_all_clients_view.dob, dbo_event_log_shack.eventtime1, dbo_event_log_shack is_deleted, dbo_event_log_shack.staff_name, dbo_event_log_shack.staff_supervisor, including cir_descrip_staff_resp rights cir_descrip_staff_resp.what_happened jOIN ((dbo_all_clients_view left dbo_all_clients_view.people_id = dbo_event_log_shack.people_id dbo_event_log_shack are) [dbo_all_clients_view query cir_descrip_staff_resp lEFT jOIN] dbo_all_clients_view.id_no = [dbo_all_clients_view query] Current .dbo_all_clients_view_id_no). [Event id] = dbo_event_log_shack.event_log_id WHERE (((dbo_event_log_shack.is_deleted) = False)) dbo_all_clients_view.full_name by ORDER, dbo_event_log_shack.actual_date DESC;

There are so many things memo fields may be truncated

< p> There is a very good list of potential reasons:

in a report, you can use another query to get DlookUp or full text of the memo.