Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

access and sql

Status
Not open for further replies.
pablohassan

pablohassan

Technical User
Nov 25, 2008
9
0
0
GB
I have sql table populated by using access form. All SQL table fields are nvarchar(50). Even if I will put just 1 character into field, after record update rest of it is filled with spaces. How can I avoid it ?
 
Sort by date Sort by votes
Use the Trim function ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
How can I use trim function directly on table or form ? I cant use query as I'm editing data.
 
Upvote 0 Downvote
In sql's triggers ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
Can you be more specific. Any example. I'm just beginning with SQL. Is my problem related to a bug in Access or is it just normal?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
168
TheresAlwaysAWay
TheresAlwaysAWay
grnzbra
  • Locked
  • Question
Using Access Database Without Having MS Access
Replies
9
Views
291
grnzbra
grnzbra
OCM
  • Question
Populate access table from excel
Replies
6
Views
233
OCM
OCM
swicor
  • Locked
  • Question
Exact match using access upper and lower case
Replies
0
Views
108
swicor
swicor
lameid
  • Locked
  • Question
Office / Access 365 Trusted locations and GP
Replies
0
Views
106
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top