Search results

Truncated Fields - My Wife is Going To Kill Me Soon Please Help. This is causing a terrible problem in that we cannot edit our fields because of this truncating problem. This was not an apparent problem earlier and I do not know what is different to have caused this. What is in the field is...

I found this in an earlier post: "Can you check if it runs from the SQL Server??? SQL Server doesn't support 'memo' it'll be varchar or nvarchar." So the question still remains, why would ntext field allow more than 255 characters and the other nvarchar repeat after 255 characters and not...

One field that works fine, is listed as data type ntext 16 and we can put in many, many characters and see it all. But the one listed as nvarchar 4000 truncates the zoomed field. What is the difference between ntext and nvarchar? Would that hinder seeing all the text in the zoom field...

Hello, Love this forum. I use Access to interface with our SQL database via an existing project. My host's technician increased the number of characters we can enter in a field. When I cut and paste into the field, it appears on the website as it should. But, when I open that field in...

Pat. Outstanding! That is perfect. Exactly what I needed. Thanks. (I pulled the shortcut menu button "Zoom" into my toolbar as well.) Thanks!

Some of my fields are hundreds of characters long. How do I see the entire field for easier editing without having to scroll back and forth? I want it to be like Excel where it shows me the entire field at the top. Or at least allowing me to switch views to see the entire field. Any...

Hello, brand new to Access and this forum. I searched and did not find this information. It's probably there but I don't know the right terms yet. I need to change the values in an entire column and increase each field by 10%. Is there a faster and easier way to change the values, rather than...

Thank you. I try to follow the instructions and there is no query design view button with the others in the objects list. If I create a DB on my computer the button is there, but not with the DB online. Could that be the difference?

I am using Access as a project connected to an SQL database on my host's server. I don't find the queries button on the left... Does this make a difference?

Hello, brand new to Access and this forum. I searched and did not find this information. It's probably there but I don't know the right terms yet. I need to change the values in an entire column and increase each field by 10%. Is there a faster and easier way to change the values, rather...