CODEWITHSUNDEEP
ms-access
user659469
user659469

Reputation: 325

ms access- performance issue with memo data type on text box

I have few text box on my sub-form. User should be able to enter more than 255 characters. So I thought of using memo data type on those text boxes. But then sub form takes 2-3 minutes to open it.

I have changed data type to Text and now I can see significant performance change. It's faster (4-5 seconds).

But now user can't enter more characters. Not even more than 100 characters. I am not sure how to achieve this. Any suggestions?

Thanks,

Upvotes: 0

Views: 135

Answers (1)

June7
June7

Reputation: 21370

This answer expands on discussion in comments below the question.

Never encountered 'record too large' error.

To normalize your database would mean adding new tables that would be dependent (children) related to the parent Specific and Blanket tables. For a starter, Blanket table has fields named Project_1, Project_2 … up to 10 as well as a bunch of other fields with the same naming convention. Normalization would have another table named maybe BlanketDetails: 

+===========+=========+============+==============+=============+  
| BlanketID | Project | Equipment  | Installation | MonForecast |  
+===========+=========+============+==============+=============+  
|         1 | C.91524 | Leonia     | Leonia       | $723,000.00 |  
+-----------+---------+------------+--------------+-------------+  
|         1 | C.91525 | Belleville | Belleville   | $258,000.00 |  
+-----------+---------+------------+--------------+-------------+

Upvotes: 1

Related Questions