Solved

Text that includes # not showing up

Posted on 2014-07-28
2
202 Views
Last Modified: 2014-07-28
My form includes a text box that the user can enter information into then click on a button to add that information into a table.

I have run into a strange problem. Every entry is working fine except one that includes the # sign. That one is in the table, but won't show up in the lists on the forms. Every other entry is working.

I suspect it is because of the # sign, but I am not sure who to get around this.

Thank you for any help you can give me!
0
Comment
Question by:Megin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 40225336
That is often a sign that the column width is too small - especially for dates. Try expanding the column width.

Kelvin
0
 
LVL 9

Accepted Solution

by:
dustock earned 500 total points
ID: 40225349
Try wrapping the pound sign in brackets  [#]
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question